hello
How can I add a second Y axis to a chart? Does the chart have to be 3-d?
Thanks
|
|
1
|
|
|
|
Reply
|
Utf
|
2/4/2010 8:56:02 PM |
|
No.
Right click on the series you want to lean on the 2nd Axis > 'Format Data
Axis > Axis tab > check 'Secondary Axis' > OK
Micky
"da" wrote:
> hello
> How can I add a second Y axis to a chart? Does the chart have to be 3-d?
> Thanks
|
|
0
|
|
|
|
Reply
|
Utf
|
2/4/2010 9:04:02 PM
|
|
da -
> How can I add a second Y axis to a chart? <
In general, you must have two or more data series. Then you select one data
series and format it to use a secondary axis.
For more specific instructions, post your version of Excel and the type of
chart.
And since your question is about charting and not misc, I suggest posting in
microsoft.public.excel.charting
> Does the chart have to be 3-d? <
I recommend that you do not use a chart that Excel calls 3D, i.e., an
unnecessary, misleading, junkie feature.
- Mike
http://www.MikeMiddleton.com
"da" <da@discussions.microsoft.com> wrote in message
news:FC755DE8-D10D-493E-AF61-4B84DAF5FBD2@microsoft.com...
hello
How can I add a second Y axis to a chart? Does the chart have to be 3-d?
Thanks
|
|
0
|
|
|
|
Reply
|
Mike
|
2/4/2010 9:12:49 PM
|
|
Thanks
I am confused.
what do you mean by series? Is that the row of numbers I want on 2nd y axis?
"מיכאל (מיקי) אבידן" wrote:
> No.
> Right click on the series you want to lean on the 2nd Axis > 'Format Data
> Axis > Axis tab > check 'Secondary Axis' > OK
> Micky
>
>
>
> "da" wrote:
>
> > hello
> > How can I add a second Y axis to a chart? Does the chart have to be 3-d?
> > Thanks
|
|
0
|
|
|
|
Reply
|
Utf
|
2/4/2010 9:28:07 PM
|
|