![]() |
Secondary Y axis and more with Pivot charts...
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 |
Secondary Y axis and more with Pivot charts...
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 |
All times are GMT +1. The time now is 12:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com