TamirBasin
New Member
- Joined
- Apr 11, 2017
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
Hello,
I have 3 Pivot tables each having rows and columns.
The number of rows and columns changes according to slicers.
Using a drop-down menu, I need to show on a chart (stacked columns) only 1 of the pivots.
Meaning, I need to alter the source of the chart dynamical.
How can I do it?
Thank you,
Tamie
I have 3 Pivot tables each having rows and columns.
The number of rows and columns changes according to slicers.
Using a drop-down menu, I need to show on a chart (stacked columns) only 1 of the pivots.
Meaning, I need to alter the source of the chart dynamical.
How can I do it?
Thank you,
Tamie