If you don’t want to move a chart while changing the width of the cell, you can lock chart position in one Excel worksheet with this guide. Although the graph moves by width and position of cells, you can turn it off.
In Excel, it is simple to insert a Gantt chart or a dynamic chart. However, the problem starts when you include more cells or columns after you insert a chart into a worksheet. By default, Excel moves the graph so that everything becomes visible without overlapping. However, sometimes you may need to correct the position of your existing graph for some reason. If yes, you can follow this tutorial.
How to lock the position of the chart in an Excel worksheet
To lock the position of a chart and prevent it from moving in an Excel worksheet, follow these steps:
- Right-click on the existing graphic.
- Select the Chart area format in the context menu.
- Switch to Size and properties tongue.
- Develop Properties.
- To select Do not move or dimension with the cells.
Let’s explore these steps in detail.
At the start, you need to insert a graph into your spreadsheet. You can enter any type of graph, be it simple 2D, 3D or something else. After adding a chart to your spreadsheet, you need to right-click on the chart.
Here you have to keep in mind one essential thing. You must right-click on the plotting area. Otherwise, you will not find the option mentioned below.
If you can right-click on the graph correctly, you should see an option called Chart area format.
After clicking on this option, you can find a sign on your right. By default, it should open Fill & Line. Yes
you have to go to the third tab, called Size and properties. After that, expand the Properties menu.
By default, it must be set to Move and size with cells, and this is why your graph moves when you enter a new column or change the width of an existing cell.
To lock the position, you must select Do not move or dimension with the cells option.
That’s all! From now on, your graph will not move even if you change the width of the cell.
I hope this simple tutorial will help you.
Now read: How to create a smooth curve graph in Excel and Google Sheets.