Excel has no null. Presumably you have formulas that either return 0 or
"". You can either delete the formulas until they are needed, or have
them return #N/A to get the desired graph.

Jerry

lk wrote:

Hi, Does anyone know how to prevent the null showing as 0 on a pivot
chart? My reports contains forcast and YTD(year to date) trend lines.
The YTD for future months are null and the nulls show as 0 on a pivot
chart which we don't want. Is there a way to prevent this? If the same
data were charted on Excel, Excel will not plot the null on pivot
chart(that's what we want).

Thanks in advance for your help.