taporctv
06-18-2007, 05:49 AM
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.