Hi,

I would like some help with macro's .... I have a data-file wich i
filled on a weekly / daily basis. Out of this data a graph is mad
(let's say On Time Delivery for a carrier). How can I make a Macro t
get excel to make a graph out of the latest ten columns/rows fille
with data?

Let's say that today's selcteion ("source data" would be A3:J3 ... ho
can i make a macro that will take B3:K3 the next time and C3:L
thereafter etc. etc.

I have a macro made myself to update a graph via "source dat" .. m
question is .. how can I make this macro more intelligent?

Thanks for your hel

--
Ferdinan
-----------------------------------------------------------------------
Ferdinand's Profile: http://www.excelforum.com/member.php...fo&userid=2992
View this thread: http://www.excelforum.com/showthread.php?threadid=49615