I can approximate a stacked time-series plot using the Combo chart option in Google Sheets:

enter image description here

But it's not quite a "real" time series plot because the temporal gaps are not represented. Compare to this Scatter chart based on the same dataset:

enter image description here

Can I have the best of both worlds: a stacked scatter plot that uses X-axis values as timestamps, not labels?

1 Answer 1


More of a workaround than answer.. but manually inserting empty rows (with dates) will pad the X-axis such that gaps are rendered:

Sheet with empty data rows added

Combo plot with gaps

Of course this requires modifying the data set, and also the dates are still treated as labels.

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.