I have a library of queries that performs counts on their respective tables in Access. Since all queries are not used all the time, I'd like to have check box within excel to select which queries to run against my Access database.

I'd like to use a bar chart to graph the counts. I want the graph to add/remove bars as the check boxes are checked/unchecked.

Does this sound like the right approach to create a dynamic chart chart? Im new to programming in vba, but i'm not new to vb.net. I just need to know where I should begin so I dont waste any effort doing the wrong approach. Let me know what you guys think.