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