How to create a chart which changes displayed data with drop down lists

[drewdicus]

Hi all,

First of all i am using Excel 2003 and am not sure if what i wish to achieve is possible but it never hurts to ask some experts!

I am trying to create a chart which has 3 drop lists, the first is a selection of 4 'targets' the second 2 will be a start and end date, once the user has made these selections the chart will then populate with the data requested.

The data in the table which feeds the chart will be updated on a daily basis so i belive this would need to be a Dynamic chart?

Apologies if i am being unclear, any help would be greatly appreciated.