Graphing Multiple Y-axes Datasets ($, %) on same X-axis (years)

**torontoguy** · 03-06-2009, 02:27 PM

Hi there,

I'm doing a financial project and need some help on graphing

I have the theoretical set:

year $ %
2003 100 10
2004 120 20
2005 145 30
2006 205 40
2007 300 50

Could I make the year the X-axis and make 2 y-axes on the same graph in excel that each datasets would be correlated to

(eg. for money it'd be from 0 to 300 while for percent it'd be from 0 to 50)

Thanks in advance for the help.

**zbor** · 03-07-2009, 06:45 AM

Select all data

year $ %
2003 100 10
2004 120 20
2005 145 30
2006 205 40
2007 300 50

Then insert Scatter chart..

Y axis will be determine from 0 to 350 (highest range)... select other one (%), right click, Format Data Series, and choose Secondary Axis instead of Primary

**torontoguy** · 03-09-2009, 08:55 AM

Ah excellent. Thanks.

I'm wondering if this can be extended with even more sets of data. Say we included interest earned, taxes, and other things as well... could we have tertiary axes and all?

**Andy Pope** · 03-09-2009, 09:00 AM

If you want more that 2 axes you will need to 'draw' them yourself using dummy series. You will also need to rescale any data used.

See Jon's page on tertiary axis. Whilst he has removed the explanation he does provide more useful alternatives, which use similar techniques.
http://peltiertech.com/Excel/Charts/TertiaryAxis.html