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.

```
 0
chowgirl
3/8/2007 10:41:35 PM
excel.charting 18370 articles. 0 followers.

3 Replies
721 Views

Similar Articles

[PageSpeed] 17

```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.
```
 0
3/8/2007 11:59:46 PM
```On Thu, 8 Mar 2007, in microsoft.public.excel.charting,

>"chowgirl" wrote:
>> 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.

>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 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?

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
```
 0
del1907 (586)
3/9/2007 9:31:48 AM
```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" <joan.maltese@21st.com> wrote in message
> 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.
>

```
 0
jonxlmvpNO (4558)
3/9/2007 5:44:23 PM