At the end of his Chart Types article:

http://pubs.logicalexpressions.com/P...cle.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.


pmguerra wrote:
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 same
format as in chart 1.

Thank you

Paulo Guerra




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html