i need to produce 20 seperate charts based on different data, and i want the
series names and markers to be the same for each chart.

question:

best way to do this with a macro?
create custom templates/palettes in excel?

any feedback appreciated

cheers, Mango

this is an interesting quesion...i would be interested if anyone can answer
"chartdummy"s question...

trying to do something similar myself

thanks, Me

"ChartDummy" wrote:

i need to produce 20 seperate charts based on different data, and i want the
series names and markers to be the same for each chart.

question:

best way to do this with a macro?
create custom templates/palettes in excel?

any feedback appreciated

cheers, Mango

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

You could make a custom chart type to apply to the data:

http://peltiertech.com/Excel/ChartsH...stomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ChartDummy wrote:

i need to produce 20 seperate charts based on different data, and i want the
series names and markers to be the same for each chart.

question:

best way to do this with a macro?
create custom templates/palettes in excel?

any feedback appreciated

cheers, Mango