Can't make secondary axis in bar chart

A

Angivan

Hi -
I've read several postings regarding adding a secondary axis to a bar
chart, but I am having a problem. When I select the data series I want
to plot on a secondary axis, the "Axis" tab does not come up, just
Patterns, Shape, Data Labels, Series Order and Options. I can get it
to work on a line graph, but I need this to be a bar chart. Help?

Thanks
 
G

Guest

what version of Excel are you working with.
I have 2002 and do not have a shape tab on my data series options.
when you click on the shape tab what do you see
 
A

Andy Pope

Hi,

You will have to use a 2d chart. Sounds like you currently have one of
the 3d style, which is why you have the shape tab instead of the axis.

Cheers
Andy
 

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

vertical scale on both ends of bar chart 1
Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? 2
Chart distorts secondary axis when the x-axis is logarithmic 5
multiple series bar and line chart 2
Line & Column on Two Axes for Blood Pressure & Weight 3
Secondary Axis 9
Assign data series to primary axis 1
Chart - Secondary Y-axis with different values/scale 2

Top