VBA - SHOW empty cells as 0 in pivot chart

Copper Contributor

Anyone an idea on how to programmatically (vba) set "show empty cells as 0" in a vba created pivot chart?

1 Reply

@EHX001 

Let's say that the chart object you created has been assigned to the variable cht.

    cht.DisplayBlanksAs = xlZero