Excel Help Needed

Associate
Joined
3 May 2006
Posts
6
good morning chaps,

i have set u a spreadsheet which produces a number of graphs, every month i add new figures to the spreadsheet and the graphs then need updating.

the graphs have a column on them for each month.

at the moment i have to go into the 'source data' for each graph in turn and extend the area to include the next months figures.

is there a way the graphs can be automatically updated when new data is entered? or a quicker/easier way of doing this than my current method?

thanks for your help

paul :)
 
thank you for the reply, sorry ive not been in the office again since i left hte post, but i have done this today and managed to get up to where you left it done without to many problems, so i think i am now upto trying the next section!!

Thanks Paul :)
 
hi,

thanks for this, i will have a play with the information you have given me this afternoon, i get the general concept so may be able to do it or get somewhere close!!

if not i will let you know!! but thanks again for your time and effort in explaining it!!


Paul
 
Back
Top Bottom