How to create a stacked chart report in ms access

[blyssz]

Hello All,
I want to produce a column chart in a report in access in which I want to stack the number of In and out balls by each category.
I am representing in by one color and out by another color in the stacked chart and have five categories (A, B, C, D , E) of balls.

The input data source is the sql query in access.
But in pivot chart, I am getting the stack of count of balls by status (in-A,B,C,D,E and Out- A,B,C,D,E)
Instead of stack of (In and Out –A), (In and Out-B)…….

Any suggestion would be appreciated
Thanks in advance,
Blyssz