<div>
It is like a circular reference, result as input to finding the result.<br />
So you must find a way to calculate the field in the pivotdata.<br />
If that is not possible, I don't have a solution.
</div>


It is like a circular reference, result as input to finding the result.
So you must find a way to calculate the field in the pivotdata.
If that is not possible, I don't have a solution.

<div>
Gave solution without having to try to calculate the field inside of the pivotdata.
</div>


Gave solution without having to try to calculate the field inside of the pivotdata.

<div>
<div class="content wysiwyg-content">
Is there a way to excludes results with a zero in a pivot table when creating a chart? I am creating a pie chart and everytime I refresh the data I get the zeros from the selected results. &nbsp;I don't want to just select the fields with data as the report I am working will be update on a weekly basis and make to minimize the amount of tweaking I have to do to the design of the report.
</div>
</div>


Is there a way to excludes results with a zero in a pivot table when creating a chart? I am creating a pie chart and everytime I refresh the data I get the zeros from the selected results.  I don't want to just select the fields with data as the report I am working will be update on a weekly basis and make to minimize the amount of tweaking I have to do to the design of the report.

Exclude Zero Results from Pivot Chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.