Skip to Content
avatar image
Former Member

Stacked Column chart dual category

Sep 11, 2014 at 05:47 AM | 6 Views

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 ?

SAP BusinessObjects Dashboards
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Arijit Das
    Sep 11, 2014 at 06:02 AM

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

    Dept. NameLargeMediumSmallA4B361C53D7
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Suman Thangadurai
    Sep 11, 2014 at 06:11 AM

    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.


    ScreenHunter_03 Sep. 11 11.48.gif (48.5 kB)
    ScreenHunter_04 Sep. 11 11.49.gif (30.4 kB)
    Add comment
    10|10000 characters needed characters exceeded