google sheetsgoogle-sheets-charts
I am trying to create a graph which shows several smooth lines that are defined by an X and Y value. the problem is that they have to share the X-axis.
Is there a way to efficiently add the other lines to this plot?
The blue line is the graph made by google sheets. I need to add the red lines. (I photoshopped them in for this example)
Google should now respect X-axis date values for Line, Area, Scatter, and Time Line charts.
For example, if you have the following data*:
| Date | Value |
|------------|-------|
| 01/01/2016 | 3 |
| 02/01/2016 | 4 |
| 03/01/2016 | 5 |
| 03/15/2016 | 6 |
| 09/01/2016 | 3 |
| 12/01/2016 | 3 |
*where the date values are stored as dates. If not, you can use =DateValue() to convert a date string to a date value.
You'd should see a lot of data in the beginning followed by a lull of activity in the middle of the year.
Area, Line, Scatter, and Time Line (located in Other) should all do so:
By contrast, bar charts continue to treat date values as a simple string and return each of the values sequentially:
And here's a public spreadsheet with all of the included examples
What you need to do is a few steps:
tldr; the Google Support answer is broken for a few chart types. Do your Axis assignments with Line charts, and change the Chart Type after.
Best Answer
all you need to do is to add more series for
Yaxis: