Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stacked Column chart dual category

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 ?

Former Member
replied

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

Dept. NameLargeMediumSmall
A4
B361
C53
D7
0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question