Using Access to create excel charts

[mharroff]

I am using Access to create and print charts in Excel.

I need to add a trendline to the chart but can't seem to get it to work.

Any help would be appreciated.

 

[MichaelRed]

This may not be the soloution for you, BUT ...

When I needed complex charts - and the 'consumer' didn't 'do access', I created an initial Excel spreadsheet by exporting a sample to a new Excel worksheet object.

Switching to Excel, I gave the data set range a name (Named Range Thinngy).

I then Created the chart in all of it's complexity IN EXCEL.

To update/propagate the function, All that was necessary was to export the data set to the named range.

This process created approx 6 different "daily" reports of activity including trend lines, bar charts and pie charts (among others).

Anyone opening the Excel workbook/worksheet only ever saw the 'current' data.

This whole process was embedded programatically into a function which was instantiated on a daily basis by data entry personnel (first log on of group member for each day). Since this group was the first to arrive/start work each day (4:30 AM!) the "daily" charts were available when the Company execs. arrived (MUCH LATTER).

I implemented this process for the customer in Oct. of '98 and worked out a few kinks in the first week. NO complaints from the customer up till the completion of the Job, in April '99.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over