A chart with 3 series?

[realsol]

I don't know how I can create this, but I need a chart that looks like the attachment. The top would be a bar chart with 2 series. One for income and on for Expenses by month of the year. I am building it from a SQL query when goes something like this:

Code: Select all

SELECT *, ABS(SUM (AMOUNT)) AS ABSTOTAL, 
  SUM (AMOUNT) AS TOTAL, 
  (cast(strftime('%d', date) as integer)) AS DAY,
  (cast(strftime('%d', date) as integer)) / 7 + 1 AS WEEK,
  (cast(strftime('%m', date) as integer)) AS MONTH,
  (cast(strftime('%m', date) as integer) + 2) / 3 as QTR,
  (cast(strftime('%Y', date) as integer)) AS YEAR
  FROM TRANSACTIONS
  INNER JOIN CATEGORIES
  ON TRANSACTIONS.TREE_NAME=CATEGORIES.CatName
  GROUP BY TREE_NAME

I figure for the Bar Chart I would use Total as from my Income category, and ABSTOTAL as the second series of the bar chart. This way the bars are all above the 0 line.

The 3rd series would use either total because it looks like the pie charts already use ABS amounts when they are built.

But I can figure out how to design it where the bar chart is above, and the pie chart is below. Also how to create the pie chart, so it is flat as it looks in the attachment.

Any help would be appreciated because this is my first project that I am using the Standard FMX TChart component.

Thanks.

[Yeray]

Hello,

Regarding the data, you should use a TSQLQuery or similar and set it to use your database. Once you have this, you should set your series to use the fields returned by the query as X values, Y values (and Labels optionally). Note the chart should be a TDBChart so the series can be set to use a DataSet as Data source.
This should be very similar to what is explained in the Tutorial 8. Database access. Find all the online Tutorials here.

Regarding the layout, I see two options:
- You can create two charts. One on the top with two TBarSeries, and one on the bottom with a TPieSeries.
- You can create a chart with a TSubChartTool. The main chart could contain the two TBarSeries and the Chart in the SubChartTool could contain the TPieSeries.

[realsol]

Thank you for this. Right now I am still trying to code the correct query to get the charts filled. I was hoping to use one query for both charts, but that didn't seem possible due to the grouping of the queries. I am currently using 2 charts on a Tabsheet. I was hoping I could position the two charts showing the 1st chart (bar) only taking up 1/3 of the page while the pie chart takes up 2/3 of the page. But I couldn't find a setting that would give positions is %'s (I want the charts to maintain their % of the screen when the application is resized), so I ended up splitting them with a splitter. Not really what I wanted to do. Is there a setting I am missing?

I didn't know about a subchart possibility. If I choose that, could I position my charts the way I want? Is that available in the Standard version of TeeCharts FMX?

I will look at the tutorials. Hopefully, they might answer my questions about sub-charts. But for some reason, I thought they were only available in the pro version.

Last Question. Is there a way to add a scroll bar to the legend? I have seen scroll bars mentioned in the forum but don't see a setting for it. Instead, my legend just cuts off the bottom when resized.

Thanks.

[Yeray]

Hello,

I am currently using 2 charts on a Tabsheet. I was hoping I could position the two charts showing the 1st chart (bar) only taking up 1/3 of the page while the pie chart takes up 2/3 of the page. But I couldn't find a setting that would give positions is %'s (I want the charts to maintain their % of the screen when the application is resized), so I ended up splitting them with a splitter. Not really what I wanted to do. Is there a setting I am missing?

You could set the Charts Height manually at OnResize event. Ie:

Code: Select all

var DBChart1, DBChart2: TDBChart;

procedure TForm1.FormCreate(Sender: TObject);
begin
  DBChart1:=TDBChart.Create(Self);
  DBChart1.Parent:=Self;
  DBChart1.Align:=TAlignLayout.Top;
  DBChart2:=TDBChart.Create(Self);
  DBChart2.Parent:=Self;
  DBChart2.Align:=TAlignLayout.Client;
end;

procedure TForm1.FormResize(Sender: TObject);
begin
  DBChart1.Height:=Self.Height/3;
end;

I didn't know about a subchart possibility. If I choose that, could I position my charts the way I want?

Same as above. You should do the calculations at OnResize event.

Is that available in the Standard version of TeeCharts FMX?

I will look at the tutorials. Hopefully, they might answer my questions about sub-charts. But for some reason, I thought they were only available in the pro version.

I'm afraid the Chart Tools are only available with the Pro version. See the feature matrix here.

Last Question. Is there a way to add a scroll bar to the legend? I have seen scroll bars mentioned in the forum but don't see a setting for it. Instead, my legend just cuts off the bottom when resized.

the TLegendScrollBar is also a Chart Tool only available with the Pro version.

[realsol]

Thanks much.

[realsol]

the TLegendScrollBar is also a Chart Tool only available with the Pro version.

Since the scrollbar is a pro version feature, is there a way to create a legend on the right that has more than 1 column in the STD version? If so, is there a way to programmatically add columns as legend items are cut off the page as the user resizes the application.

[Yeray]

Hello,

Since the scrollbar is a pro version feature, is there a way to create a legend on the right that has more than 1 column in the STD version? If so, is there a way to programmatically add columns as legend items are cut off the page as the user resizes the application.

I'm afraid the legend doesn't support this level of customization.

[realsol]

Thanks for the reply. Now with us 11 hours apart, i got up at 4 am hoping you would answer some of my questions. Thank you.