PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Re: Two y-axes needed on a scatter plot

Reply

Re: Two y-axes needed on a scatter plot

 
Thread Tools Rate Thread
Old 13-07-2004, 04:46 PM   #1
Frank Kabel
Guest
 
Posts: n/a
Default Re: Two y-axes needed on a scatter plot


Hi
if the data series is already in your chart right-click with the mouse
on this series. In the appearing context menu choose the first menu
option (something like 'selected object'). In the appearing dialog goto
the tab 'Axis' and select the second axis

--
Regards
Frank Kabel
Frankfurt, Germany


SLynn wrote:
> I have 2 sets of data that I'd like to plot on the same chart,
> even though the range of values is very different. How do I put
> another y-axis on my chart, with one side being a certain range of
> values, and the other being another range of values? In Excel help,
> it says to click the data series I want to add, and click "Selected
> Data Series" from the format menu. I've looked everywhere and I
> don't see Selected Data Series in Format or in any other buttons.
>
> Does anyone have an idea of how to do this? Thanks so much!


  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off