CR XI Issue with Stacked Bar Chart

[Former Member]

I'm hoping this question is easy.

I'm having trouble creating a stacked bar chart.

I want to do a Bar Chart which will show one "Bar" for each Priority (Priority 1, 2, 3, 4 or 5) and then for each Priority divide out, by color, the Status (Submitted, Reviewing, Working, Testing....).

For example, let's say that there are 10 Priority 1 records. Of those 10, 5 have a Status of Submitted, 3 are being Reviewed and 2 are being Tested. Then the Priority 1 bar should show a count of 10 which is comprised of 3 colors which will correspond to the 3 Statuses that make up the 10 Priority 1 records.

I can't get the Stacked Bar Chart to display this correctly.

In the Chart Expert, the Data Tab says:

-- On change of: Priority - Ascending

-- Show Value(s): Count of Status

When I run the CR, it get's the Priority correct and I see the total for each Priority. But it does not then take each Bar and color code by Status.

Any ideas how to get it to do that?

Thanks,

[Former Member · Accepted solution]

Please let me know if the description of my issue is unclear.

Separate from the example I gave, if anyone has figured out how to get a stacked bar chart to display and can explain, that would be great.

Thanks.

[Former Member · Accepted solution]

Hi,

You should have in On change of field a sub group as well.

For stacked bar charts it is necessary to have a group and a sub group fields in on change of section.

Say you have the month.

no of priority1 in jan etc.

Hope that helps!!

Thanks

-Azhar

Edited by: Azhar on Aug 4, 2009 8:23 AM

[Former Member]

Thanks Azar. It worked great.

And, well.... I swear I tried that in one of my 1000 different ways to get it working/displaying correctly before I posted.

Have a good day.