Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 13
Default date and time on line chart

I have a date and time stamp automatically generated (with a macro) when a
value is entered into the neighboring cell. The actual time between entries
is not important so I want a line chart, not XY. I can't get the line chart
to recognize the time component of date/time stamp. All entries for one day
end up piled on top of one another. How do I get XL to plot the time
component as well?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default date and time on line chart

See my reply in the other thread you started.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"bflorox" wrote in message
...
I have a date and time stamp automatically generated (with a macro) when a
value is entered into the neighboring cell. The actual time between
entries
is not important so I want a line chart, not XY. I can't get the line
chart
to recognize the time component of date/time stamp. All entries for one
day
end up piled on top of one another. How do I get XL to plot the time
component as well?

Thanks.



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
Create vertical line to indicate date on chart with series of date ryguy7272 Charts and Charting in Excel 1 January 11th 08 06:36 PM
line chart over time [email protected] Charts and Charting in Excel 3 September 5th 06 03:12 AM
Adding series, this time with a 2 axes line chart Barb Charts and Charting in Excel 1 December 9th 05 08:48 AM
Time line chart Confused Charts and Charting in Excel 2 June 3rd 05 06:32 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM


All times are GMT +1. The time now is 09:52 AM.

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"