ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Secondary Y axis and more with Pivot charts... (https://www.excelbanter.com/charts-charting-excel/141802-secondary-y-axis-more-pivot-charts.html)

SGS

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





Jon Peltier

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