Pie Chart displaying 0% labels

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
 
D

Duane Hookom

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: want separate chart for each "RN" 1
Pie Chart will only Display one slice - 100% 1
Pie Chart 8
Hiding Zero Results on Pie Chart 4
Access Pie Chart 7
Specific colors in a pie chart 3
Help with MS Access Chart in Report 3

Top