Dynamic Graph not updating itself...

[Guest]

Hi,

I've generated a (supposedly) dynamic graph using the OFFSET function to
define the data range. Whenever I add new values the range Name updates
(clicking on it highlights the correct range), however the graph that
displays this data doesn't update.

Does anyone have any ideas?

Thanks
George

 

[Don Guillett]

did you use
=nameofmyexcelworkbook.xls!myrange

 

[Guest]

Aha, that's the problem

Thanks very much for the reply. Just another quickie if you can!

I've defined all the separate ranges as names now. I've defined my X axis
(for all graphs) as the Date column. Two things happened here...

Firstly when I included the header cell (containing "Date") in the range my
graph started with "Date" on the X axis - with no values for it.

Second, I removed the header cell from the named range and now the graph
starts at the correct date, but doesn't have any data for that particular
value.

I've checked the other named ranges and they still include all the relevant
data, it's just the graph that seems to think there's no data for that
particular date...

Any ideas? I should be able to pull the relavant pages out from my worksheet
and attach if you feel's it's necessary!

Thanks
George

 

[Guest]

Actually to my second question on my previous reply, I've just noticed that
i've been including the header cell in all my data value ranges...just
knocked it out and it's all back to normal!!

Thanks for your reply

 

[Don Guillett]

glad you got it worked out

 

[Guest]

Thanks Don, Top work on your help though. It certainly helped me narrow down
my options...

I'm sometimes far too quick to ask for help when I should be able to work it
out for myself