PDA

View Full Version : Automatically change size of pivot chart based on the number of filtered results



Tanner_2004
08-25-2015, 06:06 PM
Good Day,

I was looking to use standard pivot chart functionality or VBA to change the size of a pivot chart (bar chart in my case) based on the number of filtered returned values. Therefore, if a slicer or pivot filter returns 5 values, it will be smaller in height than the same pivot chart with 20 returned values.

Thank you for reading and any guidance.