View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Rolf Barbakken Rolf Barbakken is offline
external usenet poster
 
Posts: 3
Default Aligning lines in a chart

I've added a XY version to http://www.questus.no/Default.aspx?tabid=38
(bottom image)

Although the defect lines look fairly good, the dates are way off. Not sure
why this is.

"Del Cotter" wrote:

On Thu, 26 Jun 2008, in microsoft.public.excel.charting,
Rolf Barbakken said:
The x-axis has dates, the y-axis has number of defects.

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.

--
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.