C
Chuck W
Hi,
I have a graph in Excel 2007 that is based on a pivot table. There is a
numerator, Denominator and Rate. The rate is formated as a percentage on the
graph. In my pivot table properties, I selected all error to show as N/A.
There are a couple of values where the numerator and denominator are both 0.
On my graph though, the data label shows as 0%. I want all 0% lables to be
blank or show as N/A rather than 0%. Is there a way to do this?
Thanks,
I have a graph in Excel 2007 that is based on a pivot table. There is a
numerator, Denominator and Rate. The rate is formated as a percentage on the
graph. In my pivot table properties, I selected all error to show as N/A.
There are a couple of values where the numerator and denominator are both 0.
On my graph though, the data label shows as 0%. I want all 0% lables to be
blank or show as N/A rather than 0%. Is there a way to do this?
Thanks,