Multiple y axis values (large & small numbers) plotted on same yearly x axis

[pault22]

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

[Kaper]

If you are interested in trends not values, why not use some normalization? for instance:
(value-min(values))/(max(values)-min(values))
or
value/max(max(values), -min(values))
first will map all values into <0,1>
second into <-1;1> (but not necesserily wholy populated)

See attachment rows 200-205 and your first graph using these normalized data instead of values. Nota I am not working in the field so just to show normalization took row 205 with this secend method and presented it on auxillary axis of the graph.

[pault22]

Hi Kaper
Thanks for your reply and workings, I think there's possibly too much happening and the chart looks quite confusing, I've been looking and trying to simplify it, maybe using multiple panel graphs, shown by this link:
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Just building the initial pivot table and segmenting looks quite difficult
Just really want it to be as simple and understandable for the audience as possible

Best,
Paul