LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default X axis collapsing to date on hourly data

Hello,

I have a spreadsheet I am trying to chart that has values by date and
time, IE

Date-Time, Value
9/17/07 20:00, 1
9/17/07 21:00, 2
9/17/07 22:00, 4
9/17/07 23:00, 1
9/18/07 00:00, 2
9/18/07 01:00, 1
9/18/07 02:00, 0

When I highlight all of the above and select "Insert Chart" and choose
line chart, it creates the chart as if it had the following
information:

Date-Time, Value
9/17/07, 8
9/18/07, 3

It also looks more like a bar chart then a line chart. Anyone have an
idea on why this would happen and how to fix it?

-Jason

 
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
How to plot hourly data mjwedeking Charts and Charting in Excel 7 May 6th 23 03:42 AM
Timeline based on hourly data Robert H Charts and Charting in Excel 1 August 27th 07 08:36 AM
Plot Hourly Data mjwedeking Charts and Charting in Excel 3 February 13th 07 10:35 PM
How to convert half hourly data into hourly kippers Excel Discussion (Misc queries) 5 February 1st 07 10:27 AM
How do I sample hourly data one time per day Doc Merkin New Users to Excel 2 September 12th 06 02:21 AM


All times are GMT +1. The time now is 05:10 AM.

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

About Us

"It's about Microsoft Excel"