PC Review


Reply
Thread Tools Rate Thread

Chart with Two Scales

 
 
Joseph M. Yonek
Guest
Posts: n/a
 
      10th Sep 2003
I have two sets of data with different scales.

How can I represent both on the same graph without distorting the scale of
one of them?


 
Reply With Quote
 
 
 
 
Wendy Moncur
Guest
Posts: n/a
 
      11th Sep 2003
If you look at the chart options and select the Axes tab,
you can have a secondary y axis and a secondary x axis.
Once they are there, use Format Axis to set the maximum
and minimum of the scale.

>-----Original Message-----
>I have two sets of data with different scales.
>
>How can I represent both on the same graph without

distorting the scale of
>one of them?
>
>
>.
>

 
Reply With Quote
 
dvt
Guest
Posts: n/a
 
      11th Sep 2003
>> I have two sets of data with different scales.
>>
>> How can I represent both on the same graph without distorting the
>> scale of one of them?


Wendy Moncur wrote:
> If you look at the chart options and select the Axes tab,
> you can have a secondary y axis and a secondary x axis.
> Once they are there, use Format Axis to set the maximum
> and minimum of the scale.


And to make that secondary y axis appear, select the series you wish to plot
against that secondary axis. From the menu, go to Format | Selected Data
series | Axis tab. Now the appropriate options should appear in the Chart
Options | Axes tab.

Dave
dvt at psu dot edu


 
Reply With Quote
 
 
 
Reply

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two scales on Chart Oziebill Microsoft Excel Discussion 2 30th Sep 2006 01:35 AM
2 scales in 1 chart Sirritys Microsoft Excel Charting 3 21st Sep 2006 03:35 PM
Set max and min scales for XY chart Alex Delamain Microsoft Excel Misc 2 3rd Sep 2004 03:30 PM
Bar chart scales Pluto Microsoft Excel Charting 1 15th Dec 2003 12:53 PM
different scales on same chart ... elizabeth Microsoft Excel Misc 4 16th Jul 2003 06:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:43 PM.