Bar graph with selection of combobox

[amitjulius]

I know there are lots of articles and videos on this title. But I have search a lot all over the internet and has not found what I am looking for.

I will try to explain with an example. Any help is greatly appreciated.

Example:

Category	Sub Category	Data 1	Data 2	Data 3
Category A	Sub Category A1	2	3	4
Category A	Sub Category A2	4	2	6
Category B	Sub Category B1	22	1	8
Category B	Sub Category B2	12	90	10
Category B	Sub Category B3	22	34	12
Category B	Sub Category B4	32	12	14
Category C	Sub Category C1	42	17	16
Category C	Sub Category C2	52	31	18
Category D	Sub Category D1	62	41	20
Category D	Sub Category D3	46	78	22
Category D	Sub Category D4	3	33	24

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

This is on worksheet1 - Called Data.
I want to create a Dashboard on worksheet2.

On worksheet2 I created an ActiveX combobox called "Category" in which I have unique Categories from column A.

On selection of a category from Category combobox, say "Category A", I want a bar graph with following data range:

Sub Category A1 2 3 4 Sub Category A2 4 2 6 <colgroup><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

On selection of a category from Category combobox, say "Category B", I want a bar graph with following data range:

Sub Category B1	22	1	8
Sub Category B2	12	90	10
Sub Category B3	22	34	12
Sub Category B4	32	12	14

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

and so on.

If I add more Categories or more Sub Categories under the existing category, it should be considered.

How can this be done?

I have the same excel that I can share.

 

[amitjulius]