Updating charts automatically when you input new data

[joUK]

I was wondering if anyone can help me, I am creating a number of charts that need to be updated annually. I am looking to make this as user friendly as possible and would like to find a way to input data into the original data source (worksheet) and for the chart to update automatically.

i.e. 2000 - 2009 (I need to add 2010, 2011 etc... with data set and for chart to update as these figures are added automatically)

Does anyone have any ideas on how to do this?

I am completely clueless with Excel so any help and step-by-step information would be very much appreciated!!!

Thanks,

 

[VoG]

Hello and welcome to MrExcel.

This should help you http://peltiertech.com/Excel/Charts/Dynamics.html

 

[joUK]

Thanks for this, it is very helpful however, as having difficulty understanding what happens after I've defined names... can you assist?

I am clueless when it comes to Excel!

Thanks in advance..

 

[VoG]

I'm not sure which of those tutorials you are following but once you've created your named ranges you change the chart's data source to those named ranges as illustrated here http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html