Lines in line chart are "agglomerating" data
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
"chowgirl" wrote:
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.
|