View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default X-axis labels wrong

"QuantumLeap" wrote in message
...
I am still having the problem that I wrote in about on the 1st of March.

I am making a graph of data collected during a time period, where the
x-axis
is the
date and the y-axis is the value collected. I have several different
series
of data and selected the appropriate cells for the data and for my x-axis
labels. I think that all of the values are plotting, but the x-axis
values
are incorrect.


X-values: A2:A621

Different series:
Y1: E2:E89
Y2: E90:E176
Y3: E177:E261
Y4: E262:E347
Y5: E348:E432
Y6: E433:E504
Y7: E505:E562
Y8: E563:E621

I am using a standard line graph and Excel 2000. This is perplexing
because
the graph is so simple and I have never had a problem like this until last
month and the problem continues.


Have you tried changing it from a line graph to XY-scatter?
--
David Biddulph