Make sure your Excel has the Developer Tab enabled following this tutorial.
I explain how you can do this below step by step!
What does it do?
Resizes all charts to a specific height and width
Copy Source Code:
</p> <p>'Make sure to change the Width and Height values below<br /> Sub ResizeAllCharts()</p> <p>Dim counter As Integer</p> <p>'Loop through all of the charts<br /> For counter = 1 To ActiveSheet.ChartObjects.Count<br /> 'Change the Height and Width values based on your requirements<br /> With ActiveSheet.ChartObjects(counter)<br /> .Height = 400<br /> .Width = 400<br /> End With<br /> Next counter</p> <p>End Sub</p> <p>
Final Result:Â
Exercise Workbook:
These are our charts:
STEP 1: Go to Developer > Code > Visual Basic
STEP 2: Paste in your code and Select Save. You can change the Height and Weight if you prefer a different size than 400. Close the window afterwards.
STEP 3:Â Let us test it out!
Open the sheet containing the charts. Go to Developer > Code > Macros
Make sure your macro is selected. Click Run.
With just one click, all of your charts are now resized!
Â
How to Resize All Charts Using Macros In Excel
Bryan
Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).
He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.