How can i apply an an existing chart format(including font sizes, headers &
footers) to many other existing charts

I believe you can select Chart Types, Custom Types, User Defined, Add ...
and give it a new name. I've never done it, but it appears to do what you
want.

"JP" wrote in message
...
How can i apply an an existing chart format(including font sizes, headers
&
footers) to many other existing charts

You can copy a chart (the chart area of an embedded chart), select a second chart,
and use Paste Special on the Edit menu, Formats option. This applies all regular
formatting from the first chart to the second, plus the axis and chart titles. It
does not copy the headers and footers from page setup.

To copy page setup, do the required page setup settings for one sheet, then select
the next sheet and press the F4 key to repeat. Do this as many times as needed.

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

JP wrote:

How can i apply an an existing chart format(including font sizes, headers &
footers) to many other existing charts