Formatting Charts

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

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