101 reputation
10
bio website jdsign.dk
location
age
visits member for 2 years, 9 months
seen Apr 29 at 12:48
stats profile views 26

Apr
29
accepted pivotslicer connected to multiple pivotcharts
Apr
7
awarded  Popular Question
Apr
6
awarded  Promoter
Apr
6
comment pivotslicer connected to multiple pivotcharts
in other words: department is above section in my data
Apr
6
comment pivotslicer connected to multiple pivotcharts
Hi again - I got it working, but it actually didn't solve my problem. The issue is that the slicer is more granular than I want graph 2 to be, so instead of "zooming in" and taking child-data also. I want to "zoom out" and take parent data based on the child that is selected through the slicer
Apr
3
comment pivotslicer connected to multiple pivotcharts
I'm trying to figure it out, but I'm having some trouble - a sample file would be much appreciated
Apr
3
asked pivotslicer connected to multiple pivotcharts
Mar
12
accepted only show pivotchart not pivot table
Mar
12
asked only show pivotchart not pivot table
Mar
9
comment Excel pivot diagram is way too wide
thank you so much, didn't know that affected the pivot diagram too, would have never figured out!
Mar
9
accepted Excel pivot diagram is way too wide
Mar
7
asked Excel pivot diagram is way too wide
Feb
25
awarded  Teacher
Feb
18
accepted excel conditional formatting AND isnumber
Feb
18
comment excel conditional formatting AND isnumber
And it actually will work in the pivot table if you just tick the "apply to all data fields"
Feb
18
awarded  Supporter
Feb
18
comment excel conditional formatting AND isnumber
Will it apply to all the cells in a pivot table even if the table expands beyond the range I have selected to start with?
Feb
18
comment excel conditional formatting AND isnumber
SiddharthRout - that's definitely what I want, only with dynamic cells
Feb
18
awarded  Commentator
Feb
18
comment excel conditional formatting AND isnumber
@SiddharthRout I'm sorry, I don't see how that's different from Peter's suggestiion, only the arguments are switched, and the values are absolute and not dynamic