Update graphs with Macro

[Ferdinand]

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

 

[Tom Ogilvy]

to find the last filled column

Dim col as Long, rng as Range
col = cells(3,"IV").End(xltoLeft).column

set rng = cells(3,col).offset(0,-9).Resize(10,1)

now use rng to set your source data in your code.

Another approach would be to use a defined name that is established with a
formula in the ReferstoRange. this is essentially the same approach with
the formula finding the lastfilled cell in the row, then offset back -9
cells and resizing to a range of 10 columns. Then you set the source range
for the graph to this defined name.