Hi -
What I've done is to create a chart template and then programmatically
replace cell references.
First, plan this out: set up your data in rows in a worksheet called
Data. Then create a chart range with a link to the first row of your
data set. Make sure that your dates for the Xrange are directly above
the data set.
Create a chart via the usual methods and format it the way you want to.
You can either save the chart in-sheet or as a separate chartsheet. In
either case, you can then record a macro: select the series you want
changed, change it and then end the macro.
The code that you then have should provide you with enough info to
provide the core of a loop to step through the data.
You can save the individual charts on a separate sheet (call it
"Charts") and then via CopyPicture you can keep the charts.
I use this basic method to create around 4000 charts every month in
around 6 hours. The code I have wouldn't make much sense to give you,
since it has all sorts of hoops that I have to jump through in order to
get the data into Excel, but the above method works great. Further, you
can also label the shapes that you insert the pictures of the chart
into in order to simply grab them from Word or PPoint, if you give them
meaningful names (like "PresPage3B" instead of "Picture 385").
John
