Prev: Chart distorts secondary axis when the x-axis is logarithmic
Next: Trend Line
From: Matt on 5 Jan 2010 06:54
Happy New Year!

I have a line chart that I want to show calll times by date (month). I show
Aug. through Dec. on the X axis and 00:00 (military time for 12am) at the
bottom of the Y Axis. Value axis minor grid lines reflect each hour for 24
hours.

The data I want to plot is currently 800 points. 2 columns date in column B
and time in column C. All I can get to show up is 152 points spread over the
entire chart. These 152 points should only be shown in Aug. not through Dec.

What am I doing wrong?
--
73,
Matt
From: Luke M on 11 Jan 2010 11:31
Instead of using a line chart, I believe you would do better with an XY
scatter chart. Have 1 series, define your x-values as column B, y-values as
column C.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Matt" wrote:

> Happy New Year!
>
> I have a line chart that I want to show calll times by date (month). I show
> Aug. through Dec. on the X axis and 00:00 (military time for 12am) at the
> bottom of the Y Axis. Value axis minor grid lines reflect each hour for 24
> hours.
>
> The data I want to plot is currently 800 points. 2 columns date in column B
> and time in column C. All I can get to show up is 152 points spread over the
> entire chart. These 152 points should only be shown in Aug. not through Dec.
>
> What am I doing wrong?
> --
> 73,
> Matt
 | 
Pages: 1
Prev: Chart distorts secondary axis when the x-axis is logarithmic
Next: Trend Line