View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Lines in line chart are "agglomerating" data

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"chowgirl" wrote in message
oups.com...
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.