You don't need a macro. Define a dynamic name that is based on the number of
numeric cells in the range, and make your chart using this data. Here are
links to examples:

http://peltiertech.com/Excel/Charts/...umnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Falah" wrote in message
...
I have 42 graphs that I'm manually updating the sources (two values and the
(X) axis label) to the most current data. I've set up the data sheet for
the
graph reference; (X) axis label (week 1 through week 52-full year) and
the
two values for all 52 weeks are linked to another spreadsheet and does not
get updated until the week is completed so until it is updated the cell
shows
#DIV/0!. I have 42 graphs that I have to manually update weekly to the
most
current week because I dont want the graph to show all 52 weeks at once. I
only want to see weeks that have only data. Is there any macro that could
automate the update of the graph to the most current week?