Adding a secondary value axis

A

Amanda

I have excel 2003, I am trying to add a secondary value axis to my chart, I
don't know how to do it??
 
L

lbb

Mike Middleton said:
Amanda -

First, you need at least two data series. Then, select one, choose Format
Selected Data Series | Axis | Secondary Axis.
Click to expand...

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.
 
A

Andy Pope

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
 
L

lbb

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.
 
C

Christine Dam Bendiksen

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:
 
A

Andy Pope

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
"Christine Dam Bendiksen" <Christine Dam
(e-mail address removed)> wrote in message
 
S

SonzAMonz

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
 

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

Similar Threads

Primary X axis to Secondary X axis 1
Finding asymptote equation and how to draw them in excel 0
Secondary axis not aligning to X axis 1
column charts with set set of data 0
Coordinate secondary y axis to primary y axis 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Secondary Axis 1
Chart distorts secondary axis when the x-axis is logarithmic 5

Top