<div>
Instead of having the value be in the pivot chart, I'd use the nz function.<br />
nz will give you whatever you want if the value is null. &nbsp;For example<br />
nz(valuename,&quot;no data&quot;) would print &quot;no data&quot; if valuename is null.<br />
You could do:<br />
<b>nz(valuename,&quot;&quot;)</b> to simply print a blank if valuename is null, and print the value otherwise.<br />
Hope this helps.<br />

</div>


Instead of having the value be in the pivot chart, I'd use the nz function.
nz will give you whatever you want if the value is null.  For example
nz(valuename,"no data") would print "no data" if valuename is null.
You could do:
nz(valuename,"") to simply print a blank if valuename is null, and print the value otherwise.
Hope this helps.


Access-EEQ24536942PivotChartWith.mdb

<div>
<div class="content wysiwyg-content">
How do you remove null values from an access pivotchart?<br />
<br />
the null values are currently showing up as zeros on the graph; I want the graph line to stop at the last true value<br />
<br />
I do not want the 'null' values showing up on the chart as zeros<br />
<br />
Issue arises as I have 2008 and 2009 data, 2008 runs from fiscal week 01-52 and 2009 runs from 01-22 (fiscal weeks 23-52 are null and show up on the graph as zeros)
</div>
</div>


How do you remove null values from an access pivotchart?

the null values are currently showing up as zeros on the graph; I want the graph line to stop at the last true value

I do not want the 'null' values showing up on the chart as zeros

Issue arises as I have 2008 and 2009 data, 2008 runs from fiscal week 01-52 and 2009 runs from 01-22 (fiscal weeks 23-52 are null and show up on the graph as zeros)

Access 2003 - Remove Null Values from Access PivotChart

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.