Excel Logo on a gray background

Ought to you insert or resize columns and rows in a spreadsheet, the build apart and dimension of your charts change. Charts robotically relocate attributable to they are build apart of dwelling to dash and resize with cells. Thankfully, you may perhaps per chance lock the build apart of a chart in Microsoft Excel.

This kind of scenario is overall in experiences and dashboards. When a user selects an merchandise in a Slicer to filter records, Excel resizes columns to suit its contents. And for the explanation that chart overlays these columns, its dimension too is adjusted.

To lock the build apart of a chart, ultimate-click on the merchandise and get the “Structure Chart Recount” option stumbled on on the bottom of the pop-up menu.

Format the chart area

Ought to you attain no longer witness the arrangement to layout the chart direct, you may perhaps well perhaps per chance additionally need clicked on the inappropriate a part of the chart. Ensure the resize handles are around the border of the chart. This confirms that the chart direct is chosen.

Resize handles on the chart

Within the Structure Chart Recount pane, click the “Size & Properties” icon.

Size and properties category

You may perhaps well perhaps per chance additionally must click the arrow to enhance the “Properties” settings in the event that they are no longer already seen.

There are two precious alternatives right here. Click “Don’t Switch Or Size With Cells” to totally lock the chart against being resized by Slicer alternatives or moved by customers adding or removing columns.

Alternatively, there shall be an arrangement to “Switch But Don’t Size With Cells” if that matches your wants better.

Prevent chart from moving with cells

RELATED: Straightforward solutions to Rating Customized Charts for Better Excel Spreadsheets

The above article may perhaps well perhaps additionally simply maintain affiliate links, which assist make stronger How-To Geek.