I want to drop a chart in my MSAccess application. Charts will be displayed on my form and output on a sperate report. I'll need to put in some programming (especially in the printed report) to handle the charting, e.g. adding series, choosing the chart type depending on the data that's being displayed, etc. Each chart could look very different for each record in the underlying table.
When I choose a chart component to insert I have three choices: Graph Control Object, MS Chart Object and MS Office Chart Object.
My question is, which is the best to use given my need for programmatic control? Or indeed, should I be using another component that would be better suited?
Thanks in advance.