7

I have inserted a chart into a Google sheet and need to modify the range of data it examines. I can manually define the range when I insert the chart using the chart editor as per the image below: chart editor

However once the chart is created I can't figure out to access this window again to change the range.

How can I modify the range of an existing chart?

4

Use "Advanced edit" option in the dropdown shown in upper right corner when the char is clicked. (It can also be accessed by right-clicking the chart.)

edit

It will bring you back to the dialog you saw when inserting the chart. Change the data range on "Chart types" tab, and click "Update".

  • Thanks! I can't believe I missed the Chart types tab at the top. – Alistair Nov 22 '15 at 20:17
  • @Alistair Wonder why Google has made it so hard. Also, in excel, when you click on a chart series, the associated range lights up so that you can modify it directly by clicking on the edge handles of the range boundary. Can't see how to do that in Google sheets – Sujay Phadke Mar 20 '17 at 5:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.