0

I am trying to make a Google Sheets line chart. Why does this not work as a data range?

A31:A69,A71:A94,D31:D68,=SUM(D69:D70),D71:D94

X-axis = column A (date)

Y-axis = column D (dollars, numeric)

Only the first range ever shows, and it deletes the SUM, so the chart just looks like a A31:A69,D31:D68 chart. Essentially, I just want to have the dollar amount for two dates combine into one (and discard the second date). I don't want to change the original cells. It makes me wonder what's the point of being able to add three or more data ranges.

Your Answer

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

Browse other questions tagged or ask your own question.