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?

1 Answer 1


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


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, 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 Mar 20, 2017 at 5:02

Your Answer

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

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