My database gets a weekly, manual, update of statistics. I do not want to
make a graph everytime it gets updated. My graph should update itself when I
add in the new values.

Can you help?

That should be the default behaviour.

Whenever you type a new value, it should be updated in the chart.

Are you saying you don't want this? And wait?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Ayesha Sohail" wrote:

My database gets a weekly, manual, update of statistics. I do not want to
make a graph everytime it gets updated. My graph should update itself when I
add in the new values.

Can you help?

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.


"Wigi" wrote:

That should be the default behaviour.

Whenever you type a new value, it should be updated in the chart.

Are you saying you don't want this? And wait?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Ayesha Sohail" wrote:

My database gets a weekly, manual, update of statistics. I do not want to
make a graph everytime it gets updated. My graph should update itself when I
add in the new values.

Can you help?

On Tue, 21 Aug 2007, in microsoft.public.excel.charting,
Ayesha Sohail said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.