second axis disappears on pivot chart when page field changed

Hey Peeps

Wonder if any can shed some light on a work around...

I create my pivot chart and all is well...
I add a second axis to the pivot chart and save my work...
I close the pivot chat and then re-open...
I select a different value from the 'pagefield' and my second axis dissappears???

Any ideas why this happen / any suggestions / work arounds?

Many thanks

Paul Brown

Pivot tables lose most of their formatting when they are refreshed.
http://pubs.logicalexpressions.com/P...?ID=209#jon026

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"paulbrown" <[email protected]> wrote
in message news:[email protected]...
>
> Hey Peeps
>
> Wonder if any can shed some light on a work around...
>
> I create my pivot chart and all is well...
> I add a second axis to the pivot chart and save my work...
> I close the pivot chat and then re-open...
> I select a different value from the 'pagefield' and my second axis
> dissappears???
>
> Any ideas why this happen / any suggestions / work arounds?
>
> Many thanks
>
> Paul Brown
>
>
> --
> paulbrown
> ------------------------------------------------------------------------
> paulbrown's Profile:
> http://www.excelforum.com/member.php...o&userid=32852
> View this thread: http://www.excelforum.com/showthread...hreadid=526665
>