Two scales on Chart

[Oziebill]

Is it possible in Excel (2003) to have a LH scale and a RH scale when
charting?

For example, in US terms, a LH scale showing Dow Jones Index (say 9000 -
12000 points) and a RH scale of a particular stock (say MS, $15 - $30) over
a period of time.

 

[Gord Dibben]

Yes, it is possible.

In help's answer wizard type "dual axis"

First hit will be "add a secondary axis"


Gord Dibben MS Excel MVP

 

[Oziebill]

Thanks - reckon that's just what I wanted.


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
: Yes, it is possible.
:
: In help's answer wizard type "dual axis"
:
: First hit will be "add a secondary axis"
:
:
: Gord Dibben MS Excel MVP
:
: On Sat, 30 Sep 2006 09:23:12 +1000, "Oziebill"
:
: >Is it possible in Excel (2003) to have a LH scale and a RH scale when
: >charting?
: >
: >For example, in US terms, a LH scale showing Dow Jones Index (say 9000 -
: >12000 points) and a RH scale of a particular stock (say MS, $15 - $30)
over
: >a period of time.
: >
: >
: >
: >
: >
: >
: