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.
Bookmarks