Microsoft Excel Tips and Tricks
In this video I demonstrate how to plot multiple lines on one Excel graph. This task is easy to achieve if your horizontal axis labels are stored as text values. If your horizontal axis labels are stored as numbers (for example, year), then Excel won’t interpret the data correctly and will try to plot your axis labels as a series.
Credit Chester Tugwell