Thread: PivotChart & Secondary Axes

Is it possible to have a pivotchart with a primary & secondary axes in Excel
2002? If so, how do you setup the secondary axes?

Thanks

Right-click on the series you want to change, and select 'Format Data
Series'
On the Axis tab, select Secondary Axis, click.

However, loss of formatting is a known problem with pivot charts, so you
may want to record a macro as you change the axis. There's information
in the following MSKB article:

Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904


controlsrfun wrote:
> Is it possible to have a pivotchart with a primary & secondary axes in Excel
> 2002? If so, how do you setup the secondary axes?
>
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

When I try this, the choice for changing to a secondary axis is greyed out
and not selectable. I know how to make a secondary axis for a regular chart
but it seems as if it can not be applied to a pivot chart?


"Debra Dalgleish" wrote:

> Right-click on the series you want to change, and select 'Format Data
> Series'
> On the Axis tab, select Secondary Axis, click.
>
> However, loss of formatting is a known problem with pivot charts, so you
> may want to record a macro as you change the axis. There's information
> in the following MSKB article:
>
> Changing a PivotChart Removes Series Formatting in Excel
> http://support.microsoft.com/?id=215904
>
>
> controlsrfun wrote:
> > Is it possible to have a pivotchart with a primary & secondary axes in Excel
> > 2002? If so, how do you setup the secondary axes?
> >
> > Thanks
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>