Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time "and" Date for data points
I have date and time in my first column for my x axis, but I can't get both
date and time to display in the chart. My data spans two weeks and now displays as I want it, but the data is useless without showing the relevant date/time for the data points (across the bottom of the chart). Is there a work around for this. I've tried different date/time cell formats which will display as I want it in the cell, but can't get the same display in the chart. I'm not sure what I'm doing wrong. Thanks for any help. Diana |
#2
|
|||
|
|||
Cowtoon wrote:
I have date and time in my first column for my x axis, but I can't get both date and time to display in the chart. My data spans two weeks and now displays as I want it, but the data is useless without showing the relevant date/time for the data points (across the bottom of the chart). Is there a work around for this. I've tried different date/time cell formats which will display as I want it in the cell, but can't get the same display in the chart. I'm not sure what I'm doing wrong. Thanks for any help. Diana What sort of graph is it ? Try formatting the graph's x axis as "hh:mm dd-mmm-yyyy" or something like that and it should show. |
#3
|
|||
|
|||
Thanks for that, coj. I was looking for how to format using exact that (or a
variation on the same theme). Now ... here's a wierd question. In Excel, there used to be a place to enter a "custom" date/time format, but I can't find it in this version. Did it get moved. To answer your question ... it's a line graph with two sets of data plotted against date-time. Thanks for your response. Diana "coj" wrote: Cowtoon wrote: I have date and time in my first column for my x axis, but I can't get both date and time to display in the chart. My data spans two weeks and now displays as I want it, but the data is useless without showing the relevant date/time for the data points (across the bottom of the chart). Is there a work around for this. I've tried different date/time cell formats which will display as I want it in the cell, but can't get the same display in the chart. I'm not sure what I'm doing wrong. Thanks for any help. Diana What sort of graph is it ? Try formatting the graph's x axis as "hh:mm dd-mmm-yyyy" or something like that and it should show. |
#4
|
|||
|
|||
Cowtoon wrote:
Thanks for that, coj. I was looking for how to format using exact that (or a variation on the same theme). Now ... here's a wierd question. In Excel, there used to be a place to enter a "custom" date/time format, but I can't find it in this version. Did it get moved. To answer your question ... it's a line graph with two sets of data plotted against date-time. Thanks for your response. Diana I don't know why Excel does this but it sometimes tries to put dates and times as just dates in the graph if the sheet's data is formatted as datetime. I've got round this in the past by reformatting the date/time in the sheet as general, then formatting the graph as "hh:mm dd-mmm-yy" Custom formattings are at the bottom of the number category in the format axis on Excel 2000 and 2003 I think |
#5
|
|||
|
|||
If you have anything other than a XY Scatter chart, XL has probably set
your x-axis type to 'Time scale'. Unfortunately, that is bad choice of a name because it is only a 'date scale'. The only alternative is to set the type to 'Category' (select the chart then Chart | Chart Options... | Axes tab). Unfortunately, that will mean all your data points will be equally spaced along the x-axis. If you are using a line chart, change your chart type to a XY Scatter chart (sub type: the kind that has a connecting line between the points). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have date and time in my first column for my x axis, but I can't get both date and time to display in the chart. My data spans two weeks and now displays as I want it, but the data is useless without showing the relevant date/time for the data points (across the bottom of the chart). Is there a work around for this. I've tried different date/time cell formats which will display as I want it in the cell, but can't get the same display in the chart. I'm not sure what I'm doing wrong. Thanks for any help. Diana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |