#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 516
Default Missing data

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default Missing data

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
connect line to data points with missing data in between ziak Charts and Charting in Excel 4 April 4th 23 10:35 AM
Missing Cloumn data when importing external data Findus Excel Discussion (Misc queries) 0 December 16th 08 11:22 AM
How to determine the cause of missing data after I importing data LMonro Excel Discussion (Misc queries) 7 October 26th 07 04:00 AM
How do i plot a data set that has one data point missing planet SA Excel Discussion (Misc queries) 1 September 9th 07 07:50 PM
Import External Data is missing some data Mark D. Brown, MSW Excel Discussion (Misc queries) 0 January 5th 06 06:43 PM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"