MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by anup on December 11, 2001 3:36 AM

I have a table of data. The date goes down, the variable goes across. I want to create a query that will allow me to select the start date, end date, and variable from drop down boxes and then display the data defined by the selections in the drop down boxes. I then want to graph the data produced.
Is this possible?

Posted by Hansoh on December 11, 2001 10:10 AM

yes, you can. use DATA-->VALIDATION-->LIST to create your drop down listboxes.

are you familiar with vlookups, hlookups? you may need these, too.

use the values in the dropdown listboxes as the SERIES data in your charts. good luck.