Pivot Chart functionality with Tchart

[den]

Has anyone been able to use Tchart to create similar functionality as PivotChart in MSAccess? Would anyone have any suggestions as how to?

I am trying to summarize data in a stacked bar series with multiple charts using the same data with each chart using a separate group of the data. I want to be able to do something similar to the multichart capability of MSAccess' PivotChart.

Any suggestions would be appreciated.

[Pep]

Hi den,

have you take a look at the TDBCrossTabSource component ?
You can find some example of use into the Demo Features projext (included into the TeeChart Pro installation).

[den]

Thanks Pep, but the TDBCrossTabSource component will not work in this case. (The legend and the colours have to be shared across all of the charts and the chart axes have to have the same y min/max values).

For those interested, I have 'developed' a solution to this problem. Be warned, however, that it took a fair amount of coding using a TChart and adding the series data programmatically!

Cheers,

Dennis

[tangone]

Hi den,

I am trying to do the similar task and have been searching for solutions up and down.
Would you be able to show how you have done this?

appreciate it.

rgds,
tangone

[den]

Tongone:

Sorry for the delay in answering this - so busy it slipped my mind.

In a nutshell, I had to create the repective charts dynamically (in Delphi) on the fly. I then dynamically added TDBCrossTabSources (again dynamically) to each chart and set their appropriate properties. Furthermore, the querys used were specifically written to 'pre-summarized' the data for use by the DBCrossTabSources.

I think you get to see that this was not trivial. If you really desire more detail, please let me know, and I will see what I can do to help.

Cheers,

Dennis