Lines in line chart are "agglomerating" data

  • Thread starter Thread starter chowgirl
  • Start date Start date
C

chowgirl

Elementary problem.

I have about 2 months worth of daily piece counts=about 60 data
points. Piece count (Y axis) against date (X axis).

Excel keeps bunching the line data into weeks.

The Base Unit for the X axis is "Days," Major Unit is 2 days and Minor
Unit is 1 day.

Why can't I get ALL data points (all 60 days) plotted separately? Why
is it rounding up to weeks?

Thanks.
 
I am not sure how to reproduce the problem that you are getting, but as a
general suggestion, try using an "XY (Scatter)" chart instead of a "Line"
chart.

The "Line" chart is misleadingly named -- it has nothing to do with whether
you want lines; rather it assumes that your x axis consists of category
labels instead of an arithmetic scale.

Jerry
 
I am not sure how to reproduce the problem that you are getting, but as a
general suggestion, try using an "XY (Scatter)" chart instead of a "Line"
chart.
Click to expand...

The timescale axis ought ot have worked; on the other hand, it was a
later kludge added to the line format to imitate an interval axis,
instead of, as you said, a category axis, so I'd not be surprised if it
screwed up.

But... silly question, chowgirl, but did you quote the day for each
piece, or the week commencing? Can we get a small sample of the relevant
spreadsheet cells to see what they look like?
 
Is your series using the actual dates for its X values? Or is there another
column that indicates "Week-Ending" which you may have inadvertently used in
the chart?

- Jon
 
Back
Top