Skip to main content

How to resize all charts or pictures in Excel quickly?

Author: Xiaoyang Last Modified: 2024-07-15

Are you struggling to manage a cluttered Excel worksheet filled with charts and pictures of various sizes? Whether you're preparing for a presentation or simply aiming to tidy up your data, uniformity can make a significant difference. This tutorial will guide you through the simple steps to resize all your charts and pictures to the same dimensions, quickly transforming your worksheet into a more organized and visually appealing space.

Resize all charts at once

Resize all pictures at once


arrow blue right bubbleResize all charts at once

To uniformly resize all charts in the active worksheet, follow these steps:

Step 1: Select all charts in active worksheet.

You can do this by holding down the Ctrl key and clicking each chart.
Alternatively, use the following VB macro to quickly select all charts:

Public Sub SelectAllCharts()
'Updated by Extendoffice 2025/7/15
ActiveSheet.ChartObjects.Select
End Sub 

Step 2: With the charts selected, the Drawing Tools will activate on the Ribbon. Navigate to the Format tab under the Drawing Tools.

Step 3: In the Size group, enter the desired height and width for the charts. See the following screenshot:

doc-resize-charts-pictures1

After these steps, all selected charts in the active worksheet will be resized to the same dimensions simultaneously.

doc-resize-charts-pictures2

Note: This method also applies to resizing pictures. To resize all pictures, use the Size group under Format tab in Picture Tools.


arrow blue right bubbleResize all pictures at once

To resize all pictures in the active worksheet efficiently, follow these steps:

Step 1: Select all pictures in active worksheet.

The following VB macro can help you select all pictures in active worksheet quickly.

Public Sub SelectAllPics()
'Updated by Extendoffice 2025/7/15
ActiveSheet.Pictures.Select
End Sub

Step 2: Right-click on any selected picture and choose Format Object from the context menu.

doc-resize-charts-pictures3

Step 3: In the Format Pictures dialog box that appears, select the Size category from the left sidebar.

Step 4: Enter the desired height and width in the Size section. See the following screenshot:

doc-resize-charts-pictures4

Step 4: Click OK to apply the changes. All selected pictures will now be resized to the specified dimensions simultaneously.

By following these two methods, you can easily standardize the size of charts and pictures in your worksheet, enhancing the uniformity and professionalism of your document.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Size doesn't work in my Excel 2013 The size of a line chart is fixed and will not change. Typical Microsoft idiots.
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations