had a look at the info suggested all looks good however I am still having
problems as I have more than 1 data series on the graph and all examples
presume no data in the cells following on from the last entry. This is not
the case for me.
Some insight:
I am using a copy/paste from MS project to produce 3 graph lines from the
same data. 1 line is planned work. Same line also produces Work carried out
(this is the one I want to adjust daily) third is forecast work (based on an
amount of work predicted to arise from known work and known work still to
carry out). First and third data sets are locked by pasting to separate
worksheets to the second data set.
--
Jimmy


"Jon Peltier" wrote:

Here are some examples of the technique Carlo is suggesting:

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

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


"carlo" wrote in message
...
Did you try to do it with dynamic named ranges?
which adjust themselves according to todays date?

then you can tell excel, that the source data is not
in a fixed range but in your named range.

hth

Carlo

On Dec 3, 12:53 pm, Jimmy D wrote:
I have a number of reporting graphs linked into a spreadsheet which I
update
on a daily basis. I then need to adjust where the graphs read to include
the
days data. This is tedious and time consuming with 16 graphs to adjust.
Is
there a macro or something I could write that would adjust the data range
automatically in excel97?Adjustment could be based on a date easily
enough.

--
Jimmy