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

[lk]

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.

 

[Prasad Yarlagadda]

I recently have gone thru this same issue but with a different chart
type. After trying to see if there is any pre-defined call that I could
use, found out that there is no such thing available. I guess enough
people have be asking questions about this, that MS came up with an
Article explaining how to overcome this. Check in msdn knowledge base
for Article # 326103.

In my code wherever the value is NULL, I set the value to 0. Then
followed the advice in that article, but I had to change the check from
NULL to 0 so that it would skip plotting lines where the value is NULL.

If(oPoint.GetValue(webConst.chDimValues) <> "") Then

to

If(oPoint.GetValue(webConst.chDimValues) <> "0") Then

HTH,
Prasad Yarlagadda