Monday, December 2, 2019

Google Sheets: Click on Chart Elements to Move and Delete

Now you can click directly on data labels, chart titles or legends and drag to reposition them. Easily reposition data labels that overlap to avoid clutter and ensure that key data points stand out. Or you can reposition the legend inside the chart area in order to maximize chart space.

Repositioning chart elements in Google Sheets

And you can easily delete elements using the delete or backspace keys.

Deleting chart elements in Google Sheets

When clicking on a group of items (like a set of data labels), the entire group will be selected first. If you want to drill down further (for example, to select an individual data label), simply click again on the specific element. 

Most chart elements can be repositioned and deleted, except those that derive their position from data. So, you can reposition elements like chart titles or legends, but data points will remain fixed.

Google Help Center: Add and edit a chart or graph 

For those who use a screen reader, chart elements will be verbalized as you navigate through them. Google Help Center: Edit spreadsheets with a screen reader