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

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.

Thank you