Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Access to create excel charts
- Thread starter mharroff
- Start date
MichaelRed
Programmer
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
