Secondary Y axis and more with Pivot charts...




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

Thanks in advance,




Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question