Thankyou for your reply. It doesn't really solve my problem though. What you
say happens when I change a value that is already plotted in the graph. When
I add in the new values they dont get updated. Maybe it has something to do
with how I select the values. I dont select the entire column, just the part
with data in it.
Selecting the entire column can actually work, though I don't do it.
I've always been happy to just alter the range manually every week or
so: it's no big deal for me.
Another technique, that I use for a chart I update daily, is to specify
one more row than I actually have in the data[*], and then *insert* a
new row using Ctrl-Shift-+ (select "whole row") every day. By inserting
the row above the empty row that my chart is referencing, I ensure my
chart references the new, inserted row as well.
If you really need it to be automatic, there are several tutorials on
the web that will show you how to use the OFFSET() function to create
ranges that update themselves when new data is added. The magic phrase
to google on is "dynamic range" (combine your query with the word
"Excel" in order to weed out all the hits about loudspeakers or colour
photography. The word "named" may help constrain the query even further,
but should not be necessary)
[*] actually two more rows in this case, but that's because I'm doing
step charts, so ignore that.
