Excel graph question

big_white_dog84 · 15 Apr 2006 at 16:07

I am trying to graph two sets of data with the same x-axis, but different y-axes. The data is two share prices over the same period, but one is 6 times higher than the other so I need each price to be shown on a different axis so I can show small changes over the period without the scale swamping the changes.

Anyone have any ideas how I can achieve this?

Lagz · 15 Apr 2006 at 16:11

Not sure about in Excel, but if you are desperate you could download matlab free trial and do it in that (although its not very user friendly unless you know a bit about programming).

big_white_dog84 · 15 Apr 2006 at 16:21

Thanks - hadn't thought about Matlab. Been staring at the icon on my desktop without thinking it could help me.

big_white_dog84 · 15 Apr 2006 at 17:27

Decided that it has to be Excel. Matlab does the job but the marker (an accounts lecturer) will be expecting to see an excel graph.

Anyone?

big_white_dog84 · 15 Apr 2006 at 17:29

Found it - Please close.

GlasgowTitan · 16 Apr 2006 at 16:36

Care to share, I need to know this too! I need a 2 lots of data with same x axis (time) but 2 y axises.... Cant figure it out. :confused:

big_white_dog84 · 18 Apr 2006 at 17:16

Go into custom charts, select line graph (or whatever) and there will be an option. Sorry for delay in replying.

thefranklin · 18 Apr 2006 at 18:09

The option is to add an axis btw.