9

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?

Improve this question

1 Answer 1

Reset to default
5

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".

Improve this answer
2
  • Thanks! I can't believe I missed the Chart types tab at the top.
    – Alistair
    Nov 22, 2015 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, 2017 at 5:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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