Thread: Preventing NULL showing as 0 on a pivot chart using Office Web Component.

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.

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.