vba code that shows all values except for empty and zero cells in the pivot table and chart

[shafiey]

Hello good time
I want a vba code that shows all values except for empty and zero cells in the pivot table and chart. So that there are no blanks in the pivot table chart. I searched on the internet and all the codes I found hid the blank value from the column, but it was visible in the chart.
Thanks

 

[shafiey]

Hello good time
I want a vba code that shows all values except for empty and zero cells in the pivot table and chart. So that there are no blanks in the pivot table chart. I searched on the internet and all the codes I found hid the blank value from the column, but it was visible in the chart.
Thanks

Following my question, I sent a screenshot. Please guide me.
I want (blank) to be unchecked automatically and not be seen on the chart by VBA code.
Thank you.