2nd Y Axis

D

da

hello
How can I add a second Y axis to a chart? Does the chart have to be 3-d?
Thanks
 
×

מיכ×ל (מיקי) ×בידן

No.
Right click on the series you want to lean on the 2nd Axis > 'Format Data
Axis > Axis tab > check 'Secondary Axis' > OK
Micky
 
M

Mike Middleton

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



hello
How can I add a second Y axis to a chart? Does the chart have to be 3-d?
Thanks
 
D

da

Thanks
I am confused.
what do you mean by series? Is that the row of numbers I want on 2nd y axis?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top