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. |
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 |