Create chart using dynamic interactive ranges to select the series in Excel 2007
- by jhc
I would like to create a non-VBA based solution to the following question:
How do I create a multi-series chart that will allow a user to select from a dropdown to change the data being graphed? I can do this already when the data series is contiguous; however, I'd like to be able to do it for non-contiguous data. Is this possible?
My data look something like this:
ID Salary Sal Min Sal Mid Sal Max Division Job Grade Job Subgrade Job
XXX 10000 5000 15000 25000 North 13 1 Programmer
XXX 12000 5000 15000 25000 North 13 1 Programmer
XXX 14000 5000 15000 25000 South 13 1 Analyst
XXX 11000 5000 15000 25000 South 13 1 Analyst
XXX 20000 5000 15000 25000 North 14 1 Super Programmer
XXX 25000 5000 15000 25000 North 14 1 Super Programmer
XXX 22000 5000 15000 25000 North 14 1 Manager
XXX 17000 5000 15000 25000 South 14 1 Manager
XXX 19000 5000 15000 25000 South 14 1 Manager
I would like to display Salary, Sal Min, Sal Mid, and Sal Max using a line graph. I would like the user to be able to select Job Grade, Division, and/or Job to determine what is charted. Is this possible? Would I somehow be able to do this if I used a pivottable or converted my data into a datatable?
Thanks.