How do I create a chart that will show 4 weeks of current info?
 

I need to be able to create a chart that will update data entered
automatically, in a chart, but is capable of showing many different options
to where the data can come from. I know excel is capable of drop down lists,
but I need to make this application as simple as possible for beginner users.
Any suggestions are welcome, thank-you