Skip to Content
0
May 10, 2013 at 08:14 PM

stacked column chart - multiple labels appearing

26 Views

Dear Gurus,

I am creating a chart in the dashboard from the BEx query.

The output of the bex query is as given below,

Category Fiscal_Year Time_category Actual_Hrs Actual_Cost Plan j-508 2010 regular 100 1000 1400 j-508 2011 overtime 20 1500 1000 j-508 2012 over overtime 30 1300 1300 j-509 2010 regular 110 1100 1100 j-509 2011 overtime 120 1300 1350 j-509 2012 over overtime 130 1240 1600

Now the chart appears like the one given below,

but the user does not want that way, he wishes to see the other way.

He wants to have only one "j-508" and one "j-509" as label and under "j-508" the bars 1,2,3 must appear

combined and under "j-509" the bars 4,5,6 must appear combined. so total 6 bars under 2 labels.

Is that possible? how to achieve this?

Attachments

Capture1.PNG (96.9 kB)
Capture2.PNG (20.0 kB)