Stacked Bar Graphs

[Dond12]

I am relatively new to Crystal Reports, so this may seem like an obvious question.

My problem is that I want to create a stacked bar graph, but can't find any instructions in the manual or online.

I have four categories of grant applications. An application can score anywhere from 10 to 100. I want to create a bar graph that shows the four categories, with each bar divided into those that scored at or above 67, and those that scored below 67.

Creating the actual report is easy: The top-level group is the category; and the next-level group shows the scores in specified order, one sub-group defined as scores at or above 67, and the other sub-group defined as scores below 67. This yields a very nice report.

However, I want to show this graphically. How do I do it?

 

[Andie]

If you are using version 7, I can help you out. From the chart expert window, select "Custom Chart - Chart Editor" after you have established which data you want to see. In the custom chart window, go to "Gallery | Vertical Bar". One of the options for vertical bar graphs is a stacked bar graph. Once you select that, you are all set.

From what I've heard, version 8 has changed the charting features around. I'm not familar with how that version is set up, but I would guess there should be something similar for you to do. Good luck!

 

[kenhamady]

Do you have 2 group levels in the report? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Dond12]

I figured out how to do it, using my favorite technique: trial and error. What I did was to create a report that grouped on scores (i.e., two groups: Equal to or above 67, and under 67). Then I did a second group for category. I did a stacked bar graph and got what I wanted, which was four bars, each composed of two smaller bars (each corresponding to the number of proposals either equal to or above 67, and under 67).

Then I created a sub-report that grouped in precisely the opposite way: the main group is category, and the sub-group is score.

It works beautifully. Once I realized that the graph could not be generated from the standard report data (but had to be generated separately, reversing the grouping order) I was all set.