Excel - Adding a secondary value axis

Asked By Amand on 21-Feb-07 09:00 PM
I have excel 2003, I am trying to add a secondary value axis to my chart, I
do not know how to do it??




Mike Middleton replied on 21-Feb-07 10:57 PM
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
lb replied on 19-Mar-07 04:02 PM
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
Andy Pope replied on 20-Mar-07 03:45 AM
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
lb replied on 20-Mar-07 08:22 AM
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 replied on 20-Mar-07 08:41 AM
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/ChartsHowTo/ClusterStack.html

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Christine Dam Bendikse replied on 03-Apr-07 07:50 AM
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 replied on 03-Apr-07 07:58 AM
The examples demonstrate how to do clustered & stacked.
Cluster only mean you want a stack of one instead of many. The technique
should work.

Maybe you could describe the data you have and how you want it presented.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
SonzAMon replied on 07-Jun-07 06:15 PM
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 replied on 07-Jun-07 06:23 PM
Have you seen this?
http://www.andypope.info/tips/tip008.htm

Cheers
Andy