Google Spreadsheets Get Easier Editing Options & Enhanced Charts [Updates]

Spreading some cheer for spreadsheet users, Google has made the process of editing data easier and quicker. Now you can totally bypass the chart editor and edit more directly by clicking on the part of the chart you want to format like the colors, legend, and labels.

As you can see in the screenshot below, the new way to edit is a handy shortcut which makes the spreadsheet program more user friendly. The quick editing function extends to any editable part of the chart like the horizontal and vertical axes and the data series on them.

The Quick Edit mode is explained in more detail on Google Docs Help. But the help page also says:

Quick Edit is not available for all chart types. Charts that don’t allow Quick Edit will not show the two buttons in the top-left corner, and can be edited only by opening Advanced Edit mode.

Google Spreadsheets also gets a Move and Resize mode for better visibility and chart design. In this mode, you can move and resize the chart to better fit in other components like axis labels and the legend. As the Google Drive blog explains:

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.

Once done, you can click back to the view mode and take a preview. The Google Drive blog also says that more charting features will be added soon.

Source: Google Drive Blog

More articles about:

2 Comments

Saikat Basu

Saikat is a techno-adventurer in a writer's garb. When he is not scouring the net for tech news, you can catch him looking for life hacks and learning tidbits. You can find him on Google+ & Twitter watching over the world.

The comments were closed because the article is more than 180 days old.

If you have any questions related to stuff mentioned in the article or need help with any computer issue, just ask it on MakeUseOf Answers.

Hide 2 Comments

  • Nicky Angel September 20, 2012
    0 likes

    Google is going slowly but surely.

    | Like
  • xbalesx September 20, 2012
    0 likes

    i love google docs…simple, fast and readily available from anywhere.

    | Like