|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 22nd, 2007, 02:00 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a secondary value axis
I have excel 2003, I am trying to add a secondary value axis to my chart, I
don't know how to do it?? 
|
|
#2
February 22nd, 2007, 03:57 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Amanda -
First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. - Mike http://www.mikemiddleton.com "Amanda" wrote in message ... I have excel 2003, I am trying to add a secondary value axis to my chart, I don't know how to do it??
|
|
#3
March 19th, 2007, 09:02 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
"Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab.
|
|
#4
March 20th, 2007, 08:45 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Hi,
The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#5
March 20th, 2007, 01:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Oooh, great catch. Well, changing the chart type gets me the Axis tab, and I
can add the secondary axis, but now the bars are superimposed on one another, which isn't what I want (or what anybody would want, I suppose). Oh well. Guess you just can't make this feature work in Excel. "Andy Pope" wrote: Hi, The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#6
March 20th, 2007, 01:41 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
To stop overlapping when using column charts and secondary axis you need
to lay your data out slightly differently. See here for pages on the subject http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy lbb wrote: Oooh, great catch. Well, changing the chart type gets me the Axis tab, and I can add the secondary axis, but now the bars are superimposed on one another, which isn't what I want (or what anybody would want, I suppose). Oh well. Guess you just can't make this feature work in Excel. "Andy Pope" wrote: Hi, The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#7
April 3rd, 2007, 12:50 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Great thread, but it doesn't quit solve my problem. I'd like the bars to be
next to eachother instead of stacked. I have looked through all the links, but it seems they all explain how to stack columns... thanks, Christine "Andy Pope" skrev: To stop overlapping when using column charts and secondary axis you need to lay your data out slightly differently. See here for pages on the subject http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy lbb wrote: Oooh, great catch. Well, changing the chart type gets me the Axis tab, and I can add the secondary axis, but now the bars are superimposed on one another, which isn't what I want (or what anybody would want, I suppose). Oh well. Guess you just can't make this feature work in Excel. "Andy Pope" wrote: Hi, The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#9
June 7th, 2007, 11:15 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Hi -
I followed these steps to add a secondary axis, but it seems that the only option offered is to add a secondary y-axis. Is there anyway to add a secondary x-axis? Thanks! ~Sonz "Andy Pope" wrote: Hi, The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#10
June 7th, 2007, 11:23 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding a secondary value axis
Have you seen this?
http://www.andypope.info/tips/tip008.htm Cheers Andy SonzAMonz wrote: Hi - I followed these steps to add a secondary axis, but it seems that the only option offered is to add a secondary y-axis. Is there anyway to add a secondary x-axis? Thanks! ~Sonz "Andy Pope" wrote: Hi, The Shape tab suggests that the chart type is one of the 3d types, in which case you can not use the secondary axis. Cheers Andy lbb wrote: "Mike Middleton" wrote: Amanda - First, you need at least two data series. Then, select one, choose Format Selected Data Series | Axis | Secondary Axis. I also have Excel 2003, and this answer -- which is right straight out of the help file -- does not work for me. Specifically, there IS no "Axis" option. When I go to Format - Selected Data Series, I get the following tabs: Patterns, Shape, Data Labels, Series Order, and Options. There is no "Axis" tab. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
