I am trying to make a Google Sheets line chart. Why does this not work as a data range?
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.