Edit charts in Google spreadsheets with just a click

Charts tell the story of our data, so we often spend a lot of time getting the formatting just right. That’s why we wanted to make that process quicker and easier in Google spreadsheets. Instead of opening the chart editor dialog to make formatting changes, you can now click directly on the part of the chart you want to modify to change things like the colors, legend, and labels.

You can now also resize and move the chart around to make room for other components like axis labels and the legend. To do this, click the background of the chart and choose the Move and Resize option. You’ll then be able to drag the edges of the chart and move it around to allow things like the legend labels to all fit on one line, like in the example below.

(Before/After)

Once you’re done editing, you can switch to view mode by clicking the button in the top left corner of the chart, where you can click to see the value of data points and use other helpful interactive features. 

We hope to add more charting features to this new quick edit experience over the coming months, so stay tuned.

Posted by: Hillel Maoz, Software Engineer