Overview
Spaghetti-like chart can be created on a Scatter chart with Show direction function.
How to create a Spaghetti chart?
- Add Scatter chart.
- On Graph layout (Ctrl+L) add two series under Line chart graph type - first series will be on x-axis, second on y-axis.
- Click on a line and under Presentation properties > Content > Show direction select an ornament.
- To add observations, right-click on some point of the line and select Add observation label.
Example
In this example we showed relationship between Brent Oil price and US oil consumption.