Slicer item value controles y-axis min and max vba code

Hello all,


Currently I use a pivot chart with slicer items. The slicer items are based on unique numbers. For certain numbers i would like to controle the max and min y-axis of the pivot chart without manual input.

I tried different ways, but cannot seem to get it to work, see attachmends for the methods i used.
I am quite new to VBA, so i hope you can help me.


Greetings Sjoerd

Hi,


I added an example of the excel programming,

Thanks in advance,

Dear PCI,


The result I expect:
If i click nr 1 in the slicer the pivot chart should have a minimum of 14 and a maximum of 18 on the y-axis. But nothing seems to happen.
For selection 4 in slicer i excpect min scale of 4 and maximum scale of 8.

For selection 2
Since i haven't set he min nor the max of the y-axis when you select 2, i expect excel will adjust this to standard settings (automatic). but we can say its 19 min and 20 max.