Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
In EXCEL, how do I make date-time the x-axis of a plot??????
Under Format/Cells/Date (or Time) I can pick a Type as 3/14/01 1:30 PM. And
entering that within a cell works fine. But if I try to use that column as the x-axis of a graph it only supports the date. For example a value for a reading at 3/14/01 1:30 PM and one given for 3/14/01 2:30 PM will appear as two events both given as 3/14/01. The date part is the x-axis, but the time part is simply lost. How can I make both date and time be on the x-axis, so two events at different times on the same day will show up separately? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
In EXCEL, how do I make date-time the x-axis of a plot??????
You have to use an XY chart to get thee fractional days (i.e., the times) to
appear. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "hic" wrote in message ... Under Format/Cells/Date (or Time) I can pick a Type as 3/14/01 1:30 PM. And entering that within a cell works fine. But if I try to use that column as the x-axis of a graph it only supports the date. For example a value for a reading at 3/14/01 1:30 PM and one given for 3/14/01 2:30 PM will appear as two events both given as 3/14/01. The date part is the x-axis, but the time part is simply lost. How can I make both date and time be on the x-axis, so two events at different times on the same day will show up separately? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
How do I plot negative bars/numbers BELOW the main axis in Excel | Charts and Charting in Excel | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Excel Charts - Time line for random points on X axis | Excel Worksheet Functions | |||
Excel: Add time to a date and time column? | Excel Worksheet Functions |