In Excel, by default, the charts are moved and sized with cells. Whenever we change the size of cells in an excel sheet, the excel will automatically adjust the size of the chart accordingly. Excel also provides us the option for chart positioning without changing the cell’s size. Usually, we move or change the size of the chart within excel to ensure that the chart will not cover its underlying data. We can move the chart to a new location in the worksheet or to a new or existing worksheet. Also, we resize or change the size of the chart for a better fit in the worksheet.

Note: We can resize the chart, move a chart within a worksheet or we can also move to a new worksheet.

Moving Charts in Excel

In Excel, We can easily move charts. Let us discuss with the help of an example. Suppose we have a chart that represents random sales data in different cities of 3 different states(You can use any dataset and insert a chart using the dataset and implement the following moving and resizing behavior). Now we will move this chart.

Move a chart within a worksheet

In this example, we will move a char within the same excel worksheet. Usually, we perform these operations in order to avoid the overlapping between the data and the charts. Following is the step-by-step implementation.

Step 1: Insert and Select the chart  

In this step, first, we’ll need to insert a chart(Here, we are using Bar Chart). Once we have created a chart then we need to select it, for this, we have to click over our chart and select it.

Step 2: Position the chart

Once we have selected the chart, we can position the chat to a new location by dragging it using the chart’s border (We can also do that by double-clicking to hold the chart and drag to a new position and rest it there).

 

Move a chart to another worksheet

In this example, we will learn to move our chart to a new worksheet. This will create a new worksheet with the specified sheet name and contains the chart. to do this follow the step by step implementation

Step 1: Insert and Select the chart  

In this step, first, we will need to insert a chart(Here, we are using Bar Chart). Once we have created our chart we need to select it, for this, we have to click over the chart and select it.

Step 2: Position the char on a new worksheet

Once we have selected the chart we need to go to Chart Design > Move Chart it will pop up a window asking about the new position to place the chart.

 

After we click on the Move Chart option, the excel will popup window where we need to put the new worksheet.

 

Once we click on the OK button excel will create a new worksheet with the name we have provided as “Sales Chart Report”.

 

Resizing Charts in Excel

Resizing of the chart includes an increase or decrease in the length or breadth of the chart. This could be easily done by holding the graph’s endpoint and dragging them to increase or decrease the size of the graph. Following is the step-by-step implementation.

Step 1: Insert and Select the chart  

In this step, first, we will need to insert a chart(Here, we are using Bar Chart). Once we have created the chart we need to select it, for this, we have to click over our chart and select it.

Step 2: Resizing the chart

In this step, we will resize the chart. For resizing the chart excel provides eight sizing handles in the chart. We can click on these handles and drag the size of the chart according to our requirements.