Preventing NULL showing as 0 on a pivot chart.

L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing NULL showing as 0 on a pivot chart using Office Web Component. 1
Null values in Pivot Chart 2
Multi Axis Pivot Chart 12
How I can set dynamic pivot table ONLY when I have enough data point 1
Charting 0
Pivot Chart Formatting 0
Pivot Charts from Excel not to update automatically 0
How do I create a trendline in a Microsoft Access Pivot Chart? 0

Top