Skip to Content
0
Former Member
Mar 18, 2009 at 04:55 PM

Designing a stacked bar graph

27 Views

I need your help in designing a stacked bar graph for the following case.

A school has many buildings. Each building has two wings - east and west. Each wing has many class room. The requirement is to display number of students in each class room i.e. stacked block of the bar graph.

Datbase table has following columns

Student id, class room, wing,building

In the data tab of the chart expert, I selected "on change of record" ,added building column and under show values I selected count of students columns. I could see bar graph showing number of students in each building. Next I added wing column under "on change of record" making it the 2nd column. As there are 2 wings I could see 2 bar for each building and number of students under wing of a building. However

I could not add the 3rd column, class room so that bar has blocks for room inside the wing. Looks like crystal report does not support 3rd col under "on change of record". Can someone help me to create a stacked bar graph for the above scenario.

Thanks,

Pradeep