How to create a dynamic chart using a pick list and a check box..

Hello I'm hoping someone can help. I have seen videos on how to create and use pick list for dynamic charts, and how to use check list for dynamic charts, however I was hoping to find a way to combine the two. So what I want for example, is to have a pick list that would choose the different charts, and then when that chart is displayed I can use check box to remove and add in various measurements on the chart. Example I could use the pick list ot pick California.. California chart would show up. That chart has multiple measurements on it..basically a combo chart that has bar graphs, and line graphs.. well I would like to use the check box feature to show the box graph or remove it showing on the line graph, and vice-versa.

Does anyone have any clue how this can be done. I know how to use check box with the index function.. and I know how to use the validation feature for a pick list/ or combo box.. but it's seems like you can only use the combo box/pick list to show one measurement on a chart not a combo chart..

I attached a file to show you the charts in first tab, a table version in second tab, and the pick list in the 3rd tab.. I don't have a check list version, but I know how it's done.

Thanks for your help. Hopefully wont need to use VB code to do this..If vb is needed hopefully it's very simple. As this is something I willneed to do variations of quite often.

Wow can't believe no-one has a solution for this!!

Thank you Teylyn.


I have attached the actual data set and chart examples.. The first tab has the table of data, the remaining tabs have all the chart examples. So what I am looking for is to be able to display each of
the charts by service location, and then have the ability to display or hide each chart measurement. So for example I could display from a drop list California's(CA) chart and then with Multiple check boxes or radial button, hide MSO opened bar graph metric, or MWO Opened line graph metric from the Chart, or hide all and only show MWO Backlog Bar graph. You will see each of these metrics on the charts.

I actually figured out how to do this. I will add instructions as soon as I can. or attach a file with example..Basically used a combination of Indexes, and if statement with vlookup.