Hi,

Is it possible to use secondary axis in a pivot chart? I want to use
secondary axis to create some milestones in my chart (something changed in
week x, for example)

I created a pivot table based on data with a weeknumber.
Now there are weeks with no data that are not displayed. Is it possible to
display weeknumbers on X-axis without any data?
In my chart numbering is like: wk 52, 2,3,4,5,6,8 and it should be wk
52,1,2,3,4,5,6,7,8.


Thanks in advance,

Stefan

You can plot any of the series in a pivot chart on the secondary axis, by
double clicking on the series and choosing Secondary on the Axis tab. You
can't add a series to the pivot chart, and showing milestones generally
requires an added series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SGS" wrote in message
i.nl...
Hi,

Is it possible to use secondary axis in a pivot chart? I want to use
secondary axis to create some milestones in my chart (something changed in
week x, for example)

I created a pivot table based on data with a weeknumber.
Now there are weeks with no data that are not displayed. Is it possible to
display weeknumbers on X-axis without any data?
In my chart numbering is like: wk 52, 2,3,4,5,6,8 and it should be wk
52,1,2,3,4,5,6,7,8.


Thanks in advance,

Stefan