Timeline for Add "Events" to a Time-Series Line Graph (Vertical line or x-y scatter)
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 12, 2018 at 15:37 | vote | accept | C Bauer | ||
| Mar 5, 2018 at 20:22 | answer | added | dav | timeline score: 2 | |
| Mar 5, 2018 at 18:43 | answer | added | Bandersnatch | timeline score: 0 | |
| Mar 5, 2018 at 16:59 | comment | added | C Bauer | I've added the data sets I am working with | |
| Mar 5, 2018 at 16:58 | history | edited | C Bauer | CC BY-SA 3.0 |
added 271 characters in body
|
| Mar 5, 2018 at 16:45 | comment | added | dav | It doesn't NEED to be a pure XY/Scatter chart, but it'll be MUCH EASIER to deal with, if it is. | |
| Mar 5, 2018 at 16:24 | comment | added | C Bauer | Red lines are "events" and I added them to illustrate what I want. Does the entire chart need to be a scatter plot? Right now the chart type is a "combo" with 1 line and 1 scatter, and the 2 tables are on separate sheets. | |
| Mar 5, 2018 at 16:17 | comment | added | Bandersnatch | Please explain more clearly. Are the red lines the "events" you've added? Are they plotted on the graph or have you drawn them as an example? I mention this because the line on the right is not vertical. If the latter, you can plot a vertical line by adding a new data series with only two points. The two x-values would be the date where you want the line to appear, and the two y-values would be 0 and 6000, or as high as you want the line to go. Also, what dav said - this needs to be a scatter plot. | |
| Mar 5, 2018 at 16:17 | comment | added | dav | Generally for something like this you'll want to use an XY/Scatter chart for everything-not a combo chart that includes a line chart component. Line charts use a categorical axis, so it can't easily match the XY horizontal axis. | |
| Mar 5, 2018 at 16:09 | comment | added | C Bauer | When I try this, the line series crushes up against the left side, then the X-Y scatter ends up crushed along the right side. I assume this has something to do with the date ranges not linking up. I come from a world where you just "add" the records in to the domain of x-values and just declare a new series for the y values, but that doesn't seem to be available here. | |
| Mar 5, 2018 at 16:06 | comment | added | mcalex | Use a secondary axis? | |
| Mar 5, 2018 at 15:50 | review | First posts | |||
| Mar 5, 2018 at 15:58 | |||||
| Mar 5, 2018 at 15:46 | history | asked | C Bauer | CC BY-SA 3.0 |