Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Lines in line chart are "agglomerating" data
On Thu, 8 Mar 2007, in microsoft.public.excel.charting,
Jerry W. Lewis said: "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 , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"line chart" won't display lines | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
How do I format the x axis on a "lines on 2 axes" chart? | Charts and Charting in Excel | |||
Showing "Meeting point" of lines in Chart | Excel Discussion (Misc queries) |