Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2nd Y Axis
hello
How can I add a second Y axis to a chart? Does the chart have to be 3-d? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2nd Y Axis
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2nd Y Axis
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" wrote in message ... hello How can I add a second Y axis to a chart? Does the chart have to be 3-d? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2nd Y Axis
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |