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.
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/
_______
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
