Four ways to resize a chart
To be able to resize a chart you must first select it, you do that by press with left mouse button on on the chart with the mouse.
Press and hold with left mouse button on dots, then drag to resize.
The corner dots behave differently, they change two sides of the chart simultaneously.
Hold SHIFT key while dragging to keep the chart aspect ratio. The aspect ratio is the proportional relationship between its width and its height.
If you change the width the height must also change in order to keep the same aspect ratio.
An aspect ratio of 1:1 means that the height and width have the same size.
Resize chart by changing column width and row height
If you happen to change the row height or column width the chart will resize and "follow" the cell grid.
Follow these steps if you don't want the chart to move or size with cells.
- Press with right mouse button on on the chart.
- Press with mouse on "Format Chart Area..."
- Press with mouse on "Properties" to expand settings.
- Select "Don't move or size with cells".
Chart settings - height and width
You can also change the chart size by going into the chart settings and change the height or width.
- Press with right mouse button on on a chart with the mouse.
- Press with mouse on "Format Chart Area..."
- Press with mouse on "Size & Properties" button.
- Change the height and width.
Resize multiple charts simultaneously
There are two ways to resize multiple charts, going into the chart settings or resize using the mouse.
Chart settings
To resize multiple charts you must select all charts with left mouse button while holding the CTRL key.
Release everything, now press with right mouse button on on one of the charts with the mouse.
Press with mouse on "Size and Properties...".
Enter the height and width.
All charts now have the same height and width.
Resize using the mouse
Select all charts with left mouse button while holding the CTRL key.
Now press and hold with left mouse button on a dot and then drag, the other charts will follow.
VBA Macro
The following macro loops through each chart on sheet1 and changes the chart height and width.
Sub Macro1()
For Each chrt In Worksheets("Sheet1").ChartObjects
chrt.Height = 144
chrt.Width = 216
Next chrt
End Sub
Get Excel *.xlsm file
Chart basics category
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
Fatou asks: Going back to my question, I had created a table and used the data to create a chart. […]
The image above shows lines between each colored column, here is how to add them automatically to your chart. Select […]
Charts category
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above […]
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
