Formatting Charts

[pmguerra]

Hi

Is there a way to format a chart autommatically?

I have a sheet with 10 charts and I want to aplly each one the sam
format as in chart 1.

Thank you

Paulo Guerr

 

[Debra Dalgleish]

At the end of his Chart Types article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=299

Jon Peltier discusses Custom Chart types, and copying formats from charts.

Another option is to record a macro as you format the first chart, then
select each of the remaining charts, and run the macro.