Weekly chart that shows usage percentage

Hi,

I've attached my current project which contains 2 worksheets. First one being the percentage of sales made using a store card over each week day.

The second in page layout format to be printable, containing a drop down menu and a bar chart. This chart should contain Sunday to Saturday on the left rather than week 7.

I'm not sure how to go about linking data in to charts to make they live, as in when the drop down box is changed then the chart pulls data from corresponding week in sheet 1 and displays relevant data in chart

I can make bar charts but can't work out how to make the chart update via using a drop down box.

Any help appreciated thanks.

Works great thanks, it was just the way of linking it all together I didn't get. And still don't really understand the formula that does the magic but again thanks.