Can't make secondary axis in bar chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angivan - 05 Oct 2005 16:38 GMT

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

Signature

Angivan

Reply to this Message

bj - 05 Oct 2005 20:35 GMT

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

> Hi -
> I've read several postings regarding adding a secondary axis to a bar
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Andy Pope - 06 Oct 2005 09:20 GMT

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

> Hi -
> I've read several postings regarding adding a secondary axis to a bar
[quoted text clipped - 4 lines]
>
> Thanks

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message