By default, Excel charts are tied to the underlying grid, meaning that they move and stretch as the underlying rows and columns are modified. But what if you want to fix the exact position of your visuals, and prevent them from distorting as you make changes to the rest of the worksheet?

In this tip, we’ll adjust the chart properties to essentially “disconnect” them from the grid.

COMMON USE CASES:

• Locking in chart positions while designing user-facing reports or dashboards
• Allowing charts to move (but not stretch) when rows are filtered or sorted