Self Generating Chart

Is there any way to make a chart based on data that is input into cells. ie you choose the dates and location and a chart is generated showing the values having looked them up in the database. Other variables could be searching for a specific sheet.

Yes.

You could have two select cells, one that looks up the the date and one for location?

You`ll probably need to use either an array or sumproduct to ensure you get the result from both the cells though.