How to get Fixed Number of Groups in Bar Chart 1

[2J]

I have created a bar chart that displays stacked bars based on a formula. However sometimes there is no data for some of the groups. I would still like to see the space where the group should be left blank so that the bars are always in the same spots no matter whether there is 1 or 4. At the moment if there are two groups, eg. the lowest and the highest then it will display them close together instead of displaying them at opposite ends with spaces left in the middle for groups 2 and three.

Can this be done?

Thanks very much.
2J

 

[lyanch]

Crystal can only report on the data it has. You will need to add "0" value data for the groups that don't exist for Crystal to be able to show them.

Lisa