Crystal Reports Legends
- by AWinters
Is there a way to force a Bar Chart legend in Crystal Report 11.5 to display its objects in a particular order?
For Example, say I am reporting on the consumption of "Bananas" and "Apples" by State. The Bar Chart should display the percentage of people who eat these fruits by county (Percent Bar Chart). The "Apples" percentage always displays on top of the bar chart and the "Bananas" on the bottom. The legend for this graph also displays the "Apple" color first, then the "Banana" color. However, if the "Banana" percentage is 0% the legend displays the "Banana" color first on the legend. This creates a inconsistent report (with plenty of complaints).
I would like the "Banana" color to always display second in the legend. Hope I didn't confuse anyone and any ideas would be helpful.