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?

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.

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.