How to Plot Multiple Lines on One Excel Chart

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/07/Plot-Multiple-Lines-in-Excel-Chart.xlsx

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
------------------------