Copy-paste chart dimensions

Modified on Thu, 22 Sep 2022 at 05:10 PM

Keeping charts consistent in Excel is something actually difficult, because of 2 reasons:

  • When a column gets resized, the size of any chart overlapping this column will be changed. 
  • Charts actually have 2 different size, one external (the size of the chart object) and one internal (the size of the Chart area). Excel does not provide any easy solution for keeping charts consistent both with the external and internal chart size.

This is why Power-user have this handy feature to copy and paste chart sizes, which will copy both the internal and the external chart size. This is very simple to use:

  • From the Excel ribbon of Power-user, click Copy chart dimensions to copy the internal and external dimensions of the selected chart. 
  • Then select another chart and click Paste chart dimensions to apply the copied dimensions.

Power-user l Copy-paste chart dimensions

Equivalent in PowerPoint
The same feature also exists somehow in PowerPoint, using the Pipette feature. With the Pipette, you can copy and paste many things including object sizes. For charts, the Pipette will copy both the external and internal size. 

Chart size between Excel and PowerPoint
Learn how you can keep the same size when copying charts from Excel to PowerPoint in this article: 
How to automatically paste charts from Excel to PowerPoint with the correct size

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article