Forum Discussion
Solved
How to create a 2 line graph of paired values with a bar linking each pair?
I've create such a graph by accident. It's described as a "Line Graph with Markers".
How can I create a new one?
Hello Modanistas​,
What you created is a Line with Markers chart using High-Low Lines.
To recreate it:
- Select your data.
- Insert > Line > Line with Markers.
- Add both series.
- Select the chart.
- Chart Design > Add Chart Element > Lines > High-Low Lines.
The High-Low Lines create the vertical connectors between the two series.
2 Replies
That worked a treat but was certainly not the way that I managed to create the original. I had to go to help to get the "add chart element" this time.
A work around is a work around, thanks again.
Hello Modanistas​,
What you created is a Line with Markers chart using High-Low Lines.
To recreate it:
- Select your data.
- Insert > Line > Line with Markers.
- Add both series.
- Select the chart.
- Chart Design > Add Chart Element > Lines > High-Low Lines.
The High-Low Lines create the vertical connectors between the two series.
