Bar stacking chart with value from one field

Hi There,

I have a field called ‘status’ in that field i use values between 1 till 5 (each value stands for the status of the record)
in the same record i use a category field (cat) which contains a category id.

a category_id comes with multiple status values
like for example
3 times the number 1
4 times the number 2
1 time the number 4
6 times the number 5

now i want to stack up the status per category in a barchart. so that each category has it’s own stacked bar with the different status values in one plain sight.

so i used grid with summary, charts and nothing seems to work.
any suggestions how i can do this properly?