Stacked Column chart dual category

[former_member672670]

Hi Guys,

I have an Excel spreadsheet table that has columns as shown below.

Dept. Name	Project Type	Project Count
A	Large	4
B	Medium	3
B	Medium	6
B	Small	1
C	Large	5
C	Small	3
D	Large	7

Now, I would like to represent the above table in a stacked column chart, where the X-Axis has Dept Name, Y-Axis has Project Count and the Stacked Column Chart has the Project Type.

Could anyone please help me achieve this in Dashboards 4.1 ?

[arijit_das · Accepted solution]

You need to form a Cross-Table like below to use this data in Stacked Column chart.

Dept. Name	Large	Medium	Small
A	4
B	3	6	1
C	5		3
D	7

[former_member182541]

This is not possible in stacked column chart, because it requires cross tab report to achieve this. Either you can use a combo box to filter the first and you can display the second level in chart or change report layout.