Forum Discussion
VBA - SHOW empty cells as 0 in pivot chart
Anyone an idea on how to programmatically (vba) set "show empty cells as 0" in a vba created pivot chart?
Let's say that the chart object you created has been assigned to the variable cht.
cht.DisplayBlanksAs = xlZero