I have a report with a group and for each group header i have a percent bar chart.  I have two values in each group - 1's and 0's. I want to show the percentage split between these values - 1's as a solid block of colour, and 0's as transparent.  So I have in the design window set series 2 of my chart to be transparent, the problem comes when i have a group where there are only 0's. It treats this as the first series and therefore uses the first series colours.  So it makes the graph actually the reverse of what it should show (if there was only 1 record it would show 100% where in fact it should be showing 0%).

 

I hope that the above makes sense and that somebody can help me solve this issue!

 

Thanks a lot in advance,

Dom