How to Chart values for Division vs Category and Sub-Category?

Hi,

I need to generate a chart for a table like below, as described -

--------------------Cat A (A)---------------Cat B (B)------------------Cat C (C)
Division----SubCat1(p)__Subcat2(q)---SubCat1(p)__Subcat2(q)----SubCat1(p)__Subcat2(q)
1-----------10___________9--------------0___________1-------------2__________5
2------------8___________1--------------11__________3-------------6__________3
3------------0___________3--------------2___________8-------------9__________17

Capture.PNG
Here's what I'm looking to achieve:

A chart that tells me for each division how many each of SubCat1 and SubCat2 exist for ex,

In Division 1, Cat A makes up 19 out which there are 10 'p's and 9 'q's.

Is there a way we can do this in Excel?

TIA.