Hi, everybody,

I have just found this newsgroup and I wonder if anyone could help me with a
problem that has suddenly turned up:

I run Excel in an Office97 package on a Win98 system computer. I have a
workbook that has one column for consecutive calendar dates and another
column, among others, with a "Weight" entry for each day. After each line
containing an entry in these two columns there are several more lines
following with various values for that day but with both the "Date" and the
"Weight" column cells empty. If anybody guessed, BTW, that this project
could have something to do with both "Weight Watchers" and my dear beloved
wife he would not be too wrong! :-)

On a separate sheet there is a line chart associated to this worksheet
table. It is set to display "Calendar Date" on the X-axis (declared as "time
axis") and the corresponding "Weight" entry for each calendar day on the
Y-axis. Currently the X-axis is scaled for one full year, i.e. from 1
January 2005 to 31 December 2005. The entire setup has been in constant use
and totally free from errors for several years running.

This morning, when I opened the workbook, the association between the table
entries and the chart display suddenly has gone awry. The line with the
"Weight" values is here, but instead of following the current date, from 1
January to 16 January, it has become stretched out from the beginning of the
year to somewhere around April or May.

Checking the data line reveals that for each datapoint the display for X and
Y are still correct - they only do not line up with the proper point on the
X-axis anymore. I have tried whatever I could think of, but to no avail. I
have even tried to re-create a new instance of that chart from scratch, but
to my utmost surprise this turned out to not display the data line at all!

I would very much appreciate any suggestion as to what could have gone wrong
here.

Thank you very much in advance for any help,

Kind regards,

Johannes