Hi WildWill

Sounds like you need to use dynamic ranges in your chart. Check out Jon
Peltier's site for details about how to do this:
http://peltiertech.com/Excel/Charts/Dynamics.html

"WildWill" wrote:

Consider the following data set (A1:F4):

05 Jan 09 12 Jan 09 19 Jan 09 26 Jan 09 02
Feb 09
Apples 14 22
Bread 02 03
Milk 10 09

I have a graph that shows me the values of Apples, Bread and Milk over time,
using the dates indicated as values on the Y-Axis. My problem is that every
week, I have to open up each graph and manually select the new data range,
since each week has an additional column of data ( I dont want the graph to
show emplty fields). E.g. in week 05 Jan, the data range for my graph will be
A1:B4, In week 12 Jan, I then have to change the range to A1:C4, etc, etc.

How can I get my graphs to auto range the data fileds always to include all
columns which have values in them?