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.