Skip to main content

Google spreadsheets updated with simplified edits & resizable charts

Google announced today on the Google Drive blog that it is updating Google spreadsheets with some new editing options and enhanced charts. The first update is the ability to click directly on any aspect of a chart to edit its colors, labels, legend, etc., without having to open the chart editor. The new quick edit mode (pictured above) will definitely make the app quicker and easier to use by providing the ability to edit the chart title, horizontal or vertical axis, legend, or any data series in just a few or less clicks.

Many chart types allow you to make formatting changes by clicking directly into the chart itself. Clicking anywhere in a line, area, bar, column, pie or candlestick chart, for example, will activate Quick Edit mode. You can then hover and click into specific areas of your chart that you’d like to modify… When you use Quick Edit, two buttons will appear in the top-left corner of your chart: View mode and Quick Edit mode. When you click into a chart, you’ll initially find yourself in Quick Edit mode. When you’re done making changes, click View mode.

You will also now be able to enter a Move and Resize mode that Google explained would allow you to “drag the edges of the chart and move it around to allow things like the legend labels to all fit on one line.” You can access the new resizing option (pictured below) by clicking the background of a chart and a selecting “Move and Resize”.

FTC: We use income earning auto affiliate links. More.

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel



Avatar for Jordan Kahn Jordan Kahn

Jordan writes about all things Apple as Senior Editor of 9to5Mac, & contributes to 9to5Google, 9to5Toys, & He also co-authors 9to5Mac’s weekly Logic Pros series and makes music as one half of Toronto-based Makamachine.