Sep 16 2022 01:32 AM
Anyone an idea on how to programmatically (vba) set "show empty cells as 0" in a vba created pivot chart?
Sep 16 2022 03:20 AM
Let's say that the chart object you created has been assigned to the variable cht.
cht.DisplayBlanksAs = xlZero