Line chart - different Y axis values?

Hello,

I want to plot a line chart with three sets of data of vastly different values. I want to compare the three trend lines on one chart together. Is there a way?

Also, my data is organised with the most recent date first in the list. When it comes to plotting the graph, the graph is inverted as a result. How can I change the data to have the most recent date at the bottom of the list?

Thanks in advance.

File attached.

Rob

Maybe there is way for all 3 series... But since column 1 and 2 are pritty much same, can you put only 3rd column into other axe?

Like... right click on Series3 -> Series Options -> Secondary Axis

Your chart will look like:

Attachment 39399

Create a line chart with all 3 series.
Set the Index series to the secondary axis.

Via chart options force the x axis to be Category

Add trend lines to all three series.