Re: Line chart - date line association gone mad!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 20:56:07 GMT

DUH! I should have thought of that, especially since it has happened
to me!

Thanks for letting everyone know what happened. 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <4%sHd.2423$2e4.2134@news.chello.at>, jcz@chello.at says...
> Advise to everybody who kindly tried to help me:
> 
> Hi, Andy,
> 
> The totally unexpected  :-)  has happened: I found the cause! It was really
> hard to locate - in a table containing several THOUSAND rows one small text
> entry composed of both letters and numbers had inadvertently slid one row
> too far and settled in a column supposed to have date entries exclusively.
> 
> Nevertheless I really appreciate your quick intervention!
> 
> Kind regards,
> 
> Johannes
> 
> "Johannes Czernin" <jcz@chello.at> wrote in message
> news:BQxGd.3106$yh1.196@news.chello.at...
> > 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 *** there is a line chart associated to this work***
> > 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
> >
> >
> >
> 
> 
>
Quantcast