I have a line chart where the X-axis is Day of Week and Y-axis is a count. The underlying sheet has Sunday dates in column A, where each row is one week apart, and columns B-H have count values for Sunday through Saturday, one week per row.

The sheet auto-updates as new data comes in, but not the chart.

In Chart Editor > Setup > Data range I specified A1:H1000, and when I click the Add Series button at the bottom the chart editor readily offers up the new rows (i.e. I don't have to specify the cell ranges, they are already detected) but I do have to explicitly click each one to add them to the chart.

Is there a way to bypass this final manual step, so the chart draws a new data series line whenever a new row of data is added to the underlying sheet?


Your Answer

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

Browse other questions tagged or ask your own question.