You have just created an amazing-looking chart for an important presentation, but then you realize you need to do it another ten times. This is a really time-consuming chore that many financial analysts have to deal with.
Don’t worry, there’s a quick and easy way to duplicate chart formats so you don’t have to waste your time doing things over and over. Spend more time analyzing your data instead of plotting it! Want to know how?
Yeah, you guessed it… Keep reading!
Quick Steps Guide
Here’s the quick steps guide:
- Select your chart
- Home > Copy or Ctrl + C
- Select the chart you want to reformat
- Home > Paste > Paste Special, Formats or Alt + E + S + T and Click OK.
- Repeat for each chart you need reformatted
How To Save Time By Copying Chart Formats In Excel
You have created and formatted the Bitcoin price chart for a presentation (left chart) and want to replicate the Bitcoin chart format to the Ethereum price chart (right chart).
Here’s the step-by-step guide on how to save yourself time doing mundane chart formats and utilize it to analyze data instead.
- Copy The Chart
Right-click and copy the chart:
Or left-click on the chart and click Copy in the Home tab:
- Select The Chart You Want To Reformat
Left-click on the chart.
- Paste Format On New Chart
Select Paste Special in the Home tab. Alternatively, the keyboard shortcut is Alt + E + S + T.
- Paste Special Menu
Select Formats and click OK.
Ta-da! Nice and easy way to replicate the format of a chart!
Related article – How To Format Like An Excel Wizard
Other Notes
- The size of the chart won’t be replicated with this function
- If you are copying a line chart format to a column chart, it will replace the column chart type and create a line chart as well
- There’s no mass chart format function, so you will still need to paste special format one chart at a time. Still beats replicating several chart formats!
Interesting read – How To Create Excel Scatter Plot With Labels