Hi All
I have a userform with 3 comboboxes. First month, Last month and Fault Category. Within sheet 1 there is a spreadsheet with a number dates and fault categories in Columns A & B with sub categories in column C
Is there a way I could use the drop downs to create a graph within the userform based on the information chosen. Its made more complicated because i want the graph to be quite specific in that for example if i chose June - July and fault category 1 I would want the graph to show the number of sub categories within Fault Category 1 over the months of June and July.
Just wondering if im asking too much of VB to be able to provide this at the touch of a button. Il be attempting to cobble something together myself but help would be appreciated.
I have a userform with 3 comboboxes. First month, Last month and Fault Category. Within sheet 1 there is a spreadsheet with a number dates and fault categories in Columns A & B with sub categories in column C
Is there a way I could use the drop downs to create a graph within the userform based on the information chosen. Its made more complicated because i want the graph to be quite specific in that for example if i chose June - July and fault category 1 I would want the graph to show the number of sub categories within Fault Category 1 over the months of June and July.
Just wondering if im asking too much of VB to be able to provide this at the touch of a button. Il be attempting to cobble something together myself but help would be appreciated.
