Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create vertical line to indicate date on chart with series of date | Charts and Charting in Excel | |||
line chart over time | Charts and Charting in Excel | |||
Adding series, this time with a 2 axes line chart | Charts and Charting in Excel | |||
Time line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |