How to Plot Multiple Lines on One Excel Chart

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.

00:00 - Introduction
00:18 - What you get if your axis labels are stored as numeric values
01:22 - SOLUTION 1: Converting numeric axis labels to text values and plotting multiple lines
02:13 - SOLUTION 2: Keeping axis labels as numeric values but still plotting multiple lines
03:10 - SOLUTION 3: Data is in separate tables, but you want to plot on the same chart
------------------------

[IvanCortinas_ES]

Excellent tutorial, as always, direct and very educational. It is a very functional case. Thank you very much Chester.

[karhukivi]

Just what I was looking for, thank you!

[SpotlightImpact]

Excellent tutorial! Thank you for posting! 🔥

[teoxengineer]

Otherway is to remove header of year column. Then, chart will refresh itself