Pie Chart displaying 0% labels

J

jen25

Hi,
I'm working with a report that has a pie chart embedded in it (Access 2003).
I have various status descriptions, with how many people are in each
category, some of which are zero, but I do not want the 0% labels to show up
on my chart.
Is there VBA code or some way to show only the statuses that are not zero?
Thanks,
Jen
 
D

Duane Hookom

Can you change the SQL of your Row Source to exclude records where the
result is 0?
 
Top