Tak, forstår fint dette link.
Men jeg har Dansk Excel 2007, i den er der ikke nogen Navn and Define (eller på dansk) i menuen Indsæt.
"What happens when you want to include more data in your chart? The easiest thing to do is to update your named range—the chart will update itself. Fill a few more rows with data beneath C30. Highlight the entire region, both new and old data. Go to the Insert menu at the top of the Excel window and choose Name then Define... You'll be tempted to click on TestResults in the list box but don't do it!
You must retype the name TestResults in the text box at the top to re-define the name as opposed to choosing the old name (with the old definition) from the list. You'll see that your chart is updated with the new data from your named range"
http://www.igetit.net/newsletters/Y02_06/NamedRange.aspx