copying chart properties between charts

  • Thread starter Thread starter Enda
  • Start date Start date
E

Enda

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,
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
 
Back
Top