Hide or disable option button or show empty graph when slicer item has no data on userform

Good Day,

I hope this mail finds you all well on this beautiful Friday.

I have a problem which seems to be difficult fro me to solve.

I have a userform with options buttons on it that activates the options available on two slicers of a pivot table.

As per the images, when there is no data for the item on the slicer it still shows me the graph of the previous option.

The data in the sheet for the pivot table is always changing.

How do I adapt the code to basically say, if the option chosen has no data, it should show the empty graph or make Image1 blank, or disbale the option button so that you can not select it in the first place.

Below is the code I am using for the slicers currently.

Any help will be highly appreciated!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I did not paste the code for the other 5 option button, because it is the same as above one.

Below is the images that shows my problem.

Thanks!

Never-mind, I found the quick fix.

It seems that it is important in the code to put the the selected item for that option first in the code. It seems to work no fine after I move it to the top and is giving me an empty graph.

Please Login or Register  to view this content.