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

#1 09-09-2005, 03:05 PM

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.

#2 09-13-2005, 12:05 PM

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)