Can't make secondary axis in bar chart

[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

[bj]

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


"Angivan" wrote:

>
> 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
>
>
> --
> Angivan
> ------------------------------------------------------------------------
> Angivan's Profile: http://www.excelforum.com/member.php...o&userid=27835
> View this thread: http://www.excelforum.com/showthread...hreadid=473432
>
>

[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

Angivan wrote:
> 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
>
>

--

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