Please help with Stacked Bar chart

[ericb1]

I have my data all grouped and sorted the way I want:

2 types of payments Payment_typeA, & Payment_typeB, grouped, then subgrouped by Date(quarterly).

When I view the data detail, it's correct, but I'm having trouble getting it into a stacked bar chart. For example, if the Count of Payment_typeA is 5000, and the count of Payment_typeB is 2000, I want the bar to be a total of 7000, with 2 different colors in it, representing the 2 types.

I can't seem to get this chart set up correctly. Any help is GREATLY appreciated, this is time sensitive. Thanks again.

 

[BobSuruncle]

In your Chart Expert, use a Percent Bar instead of stacked and see if that works.


Bob Suruncle