Hi all,
I would greatly appreciate help with the following.

I have several charts that I wish to use in a document such that all
charts have a uniform look. I have set all the chart properties on one
chart and now wish to copy those properties to another chart. Is there
an easy way to do this please or has anyone written a suitable macro?

Chart dimensions are most important but I would also like to copy
properties like:
All font settings for Legend, Title, Axes etc
Plot Area settings such as size and border
Legend settings suc has size and fill

Regards,

Enda

Enda -

If you don't mind retyping the axis titles and chart title, you can
select the chart area of the chart you've formatted, then select a chart
to be formatted, choose Paste Special from the Edit menu, and select the
Formats option. Any text in the titles is copied into the new chart with
the formatting.

More involved, but more permanent, is to make a custom chart type of the
style you've created. Right click the chart, select Chart Type from the
pop up menu, click on the Custom Types tab, select the user defined
option at the bottom, click the Add button below that, and enter a name
and description. Now this type is available to you for applying to any
existing or new chart. Again, titles overwrite those in the chart you're
applying the formats to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Enda wrote:
> Hi all,
> I would greatly appreciate help with the following.
>
> I have several charts that I wish to use in a document such that all
> charts have a uniform look. I have set all the chart properties on one
> chart and now wish to copy those properties to another chart. Is there
> an easy way to do this please or has anyone written a suitable macro?
>
> Chart dimensions are most important but I would also like to copy
> properties like:
> All font settings for Legend, Title, Axes etc
> Plot Area settings such as size and border
> Legend settings suc has size and fill
>
> Regards,
>
> Enda

Jon,
Thanks for your helpful reply.
Unfortunately, the approach you suggest also sets the axes scales and
units and doesn't set the plot area of chart area size. These are most
critical when trying to produce uniform charts for my article.
I've begun work on some VBA that will copy just the relevant chart
properties. If I have time to finish it I'll post it back here.

Regards,
Enda

Jon Peltier <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> Enda -
>
> If you don't mind retyping the axis titles and chart title, you can
> select the chart area of the chart you've formatted, then select a chart
> to be formatted, choose Paste Special from the Edit menu, and select the
> Formats option. Any text in the titles is copied into the new chart with
> the formatting.
>
> More involved, but more permanent, is to make a custom chart type of the
> style you've created. Right click the chart, select Chart Type from the
> pop up menu, click on the Custom Types tab, select the user defined
> option at the bottom, click the Add button below that, and enter a name
> and description. Now this type is available to you for applying to any
> existing or new chart. Again, titles overwrite those in the chart you're
> applying the formats to.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Enda wrote:
> > Hi all,
> > I would greatly appreciate help with the following.
> >
> > I have several charts that I wish to use in a document such that all
> > charts have a uniform look. I have set all the chart properties on one
> > chart and now wish to copy those properties to another chart. Is there
> > an easy way to do this please or has anyone written a suitable macro?
> >
> > Chart dimensions are most important but I would also like to copy
> > properties like:
> > All font settings for Legend, Title, Axes etc
> > Plot Area settings such as size and border
> > Legend settings suc has size and fill
> >
> > Regards,
> >
> > Enda