charts which update when a single cell changes

Hi everyone, I'm trying to create a chart that will update when a certain cell changes. The cell (A1) contains a drop down list which each month in it. I have a table with data in for all months. I want a chart that will change when a certain month is selected. So I would like when November is selected for November's info to be shown in a chart.
I've uploaded my spreadsheet for some help. The first tab has all the info. The second tab is a reporting tab. IDEALLY I would like a line chart that only shows information up to the month selected. so if May is selected I would like the bar chart to show information Jan-May. But I do not want it to show a zero value for months that have not been filled yet...
I hope this makes sense! Any help would be so appreciated.
Thank you

Hey mate,

I am working on a similar thing and aksing a similar question where i do not want the graph to plot zero values.

However i did set it up so it will automatically plot what month you want. It is a little messy, but you can clean it up if you want.

let me know if this solves your problem.

Cheers - Blake

hey! thanks so much, i am going to have a play around with it and see if i can understand it...but it looks like it could definitely help me!! i'll let you know. i would also like to create a line chart which will show data up to that month so if i select november it will only show up to november. i may be able to work this out from your sheet though, thank you.

I have changed it to a line graph, for you and also put the function =IF(OR(Sheet1!L6=0,Sheet1!L6=""),NA(),Sheet1!L6) to make the graphing only graph up to date data.

Does this work for you??

hmm, i'm a little confused. it might work, i'm going to try and apply it and see if i can understand it.
thanks so much for your help.