Autosize the height of a pivot chart based on the number of filtered values

[Tony_Caliente]

Hello,

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.

[Excel Fox]

Tony, do you have an examlpe that you can share? Just reading what you mentioned makes sense, but it would be easier with the actual working sample.

[Tony_Caliente]

I have to find a table with dozens of records; I will send shortly. Thank you.