How to resize a chart in Excel
You can watch a video tutorial here.
When a chart is created in Excel, it is created as an object. This means that it is not tied to a particular cell and is an independent entity that can be moved or resized according to the requirement. You may need to resize a chart to make it fit better on a sheet or to make the data displayed clearer for the reader.
Option 1 – Use the sizing handles
Step 1 – Select the chart

- Select the chart
- Move the pointer over the lower right corner of the chart till it changes to a sizing handle (double-sided arrow)
Step 2 – Drag the sizing handle

- Drag the sizing handle out to increase the size of the chart
- Release the sizing handle when the chart reaches the desired size
Step 3 – Check the result

- The size of the chart is increased
Option 2 – Use the menu option
Step 1 – Summon the Format menu

- Select the chart
- The Format menu option will appear
Step 2 – Resize the chart

- Go to Format > Size
- Change the height and/or width of the chart using the arrow buttons or by typing the numbers
Step 3 – Check the result

- The size of the chart changes according to the dimensions given