Pie Chart displaying 0% labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Can you change the SQL of your Row Source to exclude records where the
result is 0?
 
Back
Top