Group:  Microsoft Excel ยป microsoft.public.excel
Thread: Two scales on Chart

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Two scales on Chart
"Oziebill" <oziebillREMXXXXXXXXXOVE[ at ]XXXXXYYYyahoo.com> 29.09.2006 23:23:12
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.







Re: Two scales on Chart
Gord Dibben <gorddibbATshawDOTca> 29.09.2006 23:38:18
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"
<oziebillREMXXXXXXXXXOVE[ at ]XXXXXYYYyahoo.com> wrote:

[Quoted Text]
>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.
>
>
>
>
>
>

Re: Two scales on Chart
"Oziebill" <oziebillREMXXXXXXXXXOVE[ at ]XXXXXYYYyahoo.com> 30.09.2006 00:35:24
Thanks - reckon that's just what I wanted.


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:ggbrh2t6h6g9rrhi446hroe7ut7u833cib[ at ]4ax.com...
: 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"
: <oziebillREMXXXXXXXXXOVE[ at ]XXXXXYYYyahoo.com> wrote:
:
: >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.
: >
: >
: >
: >
: >
: >
:


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net