Bar chart

[taporctv]

I have a list of queries that a user can select from (20+ queries). Based on the queries chosen, I want to generate a bar chart. The data from the queries are already written to a another sheet within the workbook. A2 has the query name and D2 has the data (and so on) I want to graph. I've been looking around the forum and see that you can use VBA to do this or do it through somekind of wizard. What approach should I take with my situation. I need some code as a reference.

[taporctv]

Ok I figured it out. I ended up not using VBA to make a dynamic chart. I found some tutorial online. I have another question. For example, I have a columnar chart that displays percentages. Is it possible to be able to click on an individual column in the graph open up and open a new sheet within the workbook?