PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Secondary Axis

Reply

Secondary Axis
 
Thread Tools Rate Thread
Old 08-11-2005, 08:20 PM   #1
=?Utf-8?B?QWxleCBNYWNrZW56aWU=?=
Guest
 
Posts: n/a
Default Secondary Axis


Is it possible to have two different scales for the vertical axis, e.g. left
hand axis is 0-100, right hand (secondary) axis as 0-10?

Thank you.
  Reply With Quote
Old 08-11-2005, 09:19 PM   #2
Andy Pope
Guest
 
Posts: n/a
Default Re: Secondary Axis
Hi,

Certainly. Once you have some data on the secondary axis double click it
to set the min and max values as required.

Cheers
Andy

Alex Mackenzie wrote:
> Is it possible to have two different scales for the vertical axis, e.g. left
> hand axis is 0-100, right hand (secondary) axis as 0-10?
>
> Thank you.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off