Hi, I have multiple y axis series I want to compare from year 1999 - 2014 (x axis)
I want to create multiple lines on a chart, comparing numbers around 100m to numbers around 1000 & even percentages (also in lines).
The scaling is not important, I would just like to identify the correlations between the movements over time.
There is a host of numbers I would like to plot, ranging from 1000, 4m, up to 120m & also percentages.
Could I fit multiple lines/series, say up to 15? all between these kind of ranges/formats? Again, the scaling is not important, rather the line correlations.
I've attached the spreadsheet & my chart attempts (below the data/row 144).
Im on excel 2010.
Your help would be greatly appreciated
Many thanks
Paul
Bookmarks