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