Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot chart issue | Charts and Charting in Excel | |||
Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
pivot chart format | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |