Personally, I'd record a macro while formatting the first chart. Then,
select each subsequent chart and run the macro. That way you work
around undesired changes to elements that XL considers part of a
chart's format but most normal people would not.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
In Excel 2002 is it possible to format more than one chart at a time or do
they have to each be formatted individually? Is it possible to format one
chart and apply the formatting to other existing charts?

I have a series of charts that need the same formatting and I'm looking for
a ay to only do it once and thus save a lot of time.

Thanks!