P
PSVSupporter
This bug occurs in Excel 2007.
If I make a pivotgraph with multiple fields, for Example Weekday, Weeknumber
and Period, I only can change the direction and spacing for the first field.
(Weekday in this example).
Spacing is also not correctly done. If I manually change the number of
values to 1, this doesn't have effect, but if I set it to automatic, it does
display all weekdays. It's not applied to the other fields.
A typical graph for a year has 356 weekdays, 52 weeks and 13 periods (of 4
weeks). I don't want all weekdays displayed, cause it's impossible to read.
But I want all weeknumbers and periodnumbers displayed.
Also I want all fields vertically displayed, but this only is applied to the
first field.
In my opinion this is a bug. Or is there somebody who can explain to me, how
I can get this done? (And I want pivotgraphs!)
If I make a pivotgraph with multiple fields, for Example Weekday, Weeknumber
and Period, I only can change the direction and spacing for the first field.
(Weekday in this example).
Spacing is also not correctly done. If I manually change the number of
values to 1, this doesn't have effect, but if I set it to automatic, it does
display all weekdays. It's not applied to the other fields.
A typical graph for a year has 356 weekdays, 52 weeks and 13 periods (of 4
weeks). I don't want all weekdays displayed, cause it's impossible to read.
But I want all weeknumbers and periodnumbers displayed.
Also I want all fields vertically displayed, but this only is applied to the
first field.
In my opinion this is a bug. Or is there somebody who can explain to me, how
I can get this done? (And I want pivotgraphs!)