View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
chowgirl chowgirl is offline
external usenet poster
 
Posts: 1
Default Lines in line chart are "agglomerating" data

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.