Inserting a Chart in your Excel spreadsheet is easy, but sometimes they will appear where you do not want them, and they can be too big or too small to show your data. Microsoft Excel can allow users to move charts from one spreadsheet to another or to move it up and down on the same spreadsheet. You can also size a chart by using the dragging technique. Charts are used globally by persons to display their data graphically.
How to move and resize a Chart in Excel
Follow the steps below to move and resize charts in Excel:
How to move a chart to a chart sheet in Excel
Select the chart, then go to the Chart Design tab.
In the Location group, click the Move Chart button.
In the Move Chart dialog box.
Select the New Sheet option.
If you want to enter a new name sheet, click the entry box and enter a name.
Click OK.
The chart will open on a chart sheet.
How to move the chart to a different Excel sheet in the same workbook
Before doing this, have more than one worksheet tab open.
Select the chart, then go to the Chart Design tab.
In the Location group, click the Move Chart button.
In the Move Chart dialog box.
Select the Object in option.
Select a sheet from the list. We choose Sheet 3.
Click OK.
The Pie Chart will move to Sheet 3.
How to resize a chart in Excel
You have two methods to resize a chart in Excel.
Method 1: Place the cursor on the pointer of the chart and drag it in the direction you want it to be, whether large or small.
Method 2: On the Format tab, in the size group, Enter a Shape Height and a Shape Width.
READ: How to create a Gauge Chart in Excel
How is moving a chart different from resizing a chart?
When you move a chart, you can place it anywhere in the worksheet or move it to a new worksheet in a different location, while resizing the chart requires you to increase or decrease the size of your chart on the worksheet.
Which Pointer do you use to resize a chart?
When you are resizing a chart, place the cursor on the pointer, which is a point on the end; the pointer will turn into a double arrow. Now drag the edge of the chart to resize the chart to the size you want.
READ: How to create a Thermometer Chart in Excel
We hope this tutorial helps you understand how to move and size charts in Microsoft Excel.
