You might be able to adapt this approach to your worksheet:

Dynamic Charting By Dates
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"Paul" wrote in message
...
I would like to build a line chart that automatically plots values for the
past 14 days, no matter when I open the chart.

I have set up a column with now() in the first cell and now()-1, now()-2,
etc. in a series for the following 13 cells down to now()-14. This column
becomes the data range for the x-axis.

If I test it by changing the system date, the now() values do not change
automatically. I know there must be a way to do that.

But the further concern is how to link values in another column with the
proper
now()-x value to display what I want to see.

I want to use this chart to be able to show my doc my sugar glucometer
readings for two weeks, whenever I open the chart.

Thanks