I suspect the problem is that the "dates" are entered in a nonstandard
format, which Excel treats as valueless text.

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


"Del Cotter" wrote in message
...
On Fri, 27 Jun 2008, in microsoft.public.excel.charting,
Rolf Barbakken said:
"Del Cotter" wrote:
Rolf Barbakken said:
The problem seems to be aligning the different lines from these
worksheets.
The groups are not on the same dates, so I have three tables that can
look
like this (only first three, sorted):

You've used a Line Chart. Use an XY (Scatter) Chart instead.

I've added a XY version
Although the defect lines look fairly good, the dates are way off. Not
sure
why this is.

It looks to me as if you haven't given it the dates at all. The positions
of the data points are date-formatted versions of 1, 2, 3, 4, 5 etc.,
which is what Excel defaults to if it hasn't got anything else to work
with.

Although an XY graph is supposed to be able to handle the word "Date" over
the date column without breaking, try taking the word out, leaving a blank
above the dates, and see if it properly picks up the X series. Create your
graph using only the first, ("fixed") series at first, then add the other
two manually using Cut and Paste Special, so that they pick up their own X
ranges instead of the first series X range.

Or use Jon Peltier's Quick XY Chart Utility to make the XY charts easily
with your chosen X and Y ranges:

http://www.peltiertech.com/Excel/Cha...rtUtility.html

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.