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.
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.
Within the Structure Chart Recount pane, click the “Size & Properties” icon.
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.
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.
How-To Geek is the build apart you flip while you happen to desire experts to advise know-how. Since we launched in 2006, our articles have been learn more than 1 billion times. Are looking to know more?
