Copy Chart Formatting

 

Did you know that you can format several of your charts in a workbook at once? Here is how to copy chart formatting.

Copy Chart FormattingLets say we are evaluating sales figures for employees and have a table like this:

We make a column chart for each employee for comparing their sales month by month. Default charts will look like this:

These charts are not very good as the are. So we are going to format them all. But since there are alot of charts and formatting to do, an easy way to make it all at once would be nice. Then we are going to format the first chart then copy chart formatting to others.

So lets make the nice thing. Format the first chart.

Select and copy the chart you formatted.

Select the chart you want all formatting to be applied and then select Paste Special from Home ribbon.

Excel will ask you what to paste. Select Formats option.

Now your chart has the same formatting as the one you manually formatted.

Repeat same copy-paste sequence to copy chart formatting other charts too.

Now you know how to copy formatting from one chart to another.

You may also like...

2 Responses

  1. February 26, 2016

    […] the same for other tables (other KPI’s), you can also copy chart formatting to do this faster. Then place these chart next to your donut […]

  2. September 30, 2016

    […] the same for other tables (other KPI’s), you can also copy chart formatting to do this faster. Then place these chart next to your donut […]

Leave a Reply

Your email address will not be published. Required fields are marked *