I have a chart on a report that is to display the “Top 3” sub categories for each of 5 different categories. Each category can have more than 3 “Top 3” sub categories due to ties for third place. They may have fewer or even zero.

The stored proc is currently returning 12 different sub categories spread among 4 categories. One has 1, two have three each and the fourth has 5. The chart is adding space for all 12 sub categories in each categories area and labeling the missing ones with zeros.

How can I get the chart to not have 12 spaces in each category and to stop showing the zeros?

data
[u]Category Sub_Category Total</u>
Project Request Project Request 3
Support Support\Fidelity\Application Support 14
Support Support\Facilities\Utilities 8
Support Support\Fidelity\Rights 7
Support Support\Hardware Support\Monitor 7
Support Support\Software Support\Microsoft Office 7
Security Security\File Access/Sharing 7
Security Security\Keys 4
Security Security\Badging 3
Purchasing Purchasing\Facilities 10
Purchasing Purchasing\Hardware 2
Purchasing Purchasing\Software 1