Timeline for Combine two rows into a single series in a line graph (Excel)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 12, 2017 at 18:01 | comment | added | Jon Peltier | Sorry for the confusion. I was replying to the OP's comment on your answer, which does in fact use specific X values. But the OP tried your approach and still did not get the chart he wanted, because I think he still does not use specifically defined X values. | |
| Jan 12, 2017 at 7:55 | comment | added | Máté Juhász | @JonPeltier: is this a comment to the question or to the answer? The example in the answer DOES USE specific x values. | |
| Jan 12, 2017 at 2:43 | comment | added | Jon Peltier | Your series apparently does not use specific X values. Instead it is using the index of each point (1, 2, 3, etc.) for X values. You need to specify X values for each series. | |
| Jan 9, 2017 at 10:41 | comment | added | petehallw | Thanks for your answer. I have added extra columns now where the duplicates need to be but I am still seeing a gradient rather than a vertical. My chart type is 'Scatter with Straight Lines'. Example image added to question - note the red line still has slopes. | |
| Jan 9, 2017 at 10:33 | history | answered | Máté Juhász | CC BY-SA 3.0 |