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?
 

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

Pie chart troubles 9
Pie Chart 8
Pie Charts 3
Pie Charts-Labels 1
Pie Chart will only Display one slice - 100% 1
Specific colors in a pie chart 3
Pie Chart: want separate chart for each "RN" 1
Deleting 0% Pie Chart Labels 3

Back
Top