![]() |
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 |
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 |
All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com