Dates Don't Display Properly in Charts

[Prhyme]

I am working with a 2-column spreadsheet. The first column is a Date and Time reading, and the second column is the value for a measurement taken at the corresponding date and time. When I attempt to create an XY Scatter Graph of this data, the chart comes out fine, but the X-Axis labels are all screwy. The dates start at 1/1/00, and I can't figure out any way to get it to correspond with what the data actually says. Any help would be greatly appreciated.[/u]

 

[venkat1926]

how is the date and time entered in the date column.
canyou send three or four examples of these entries.

 

[Prhyme]

Date / Time
8/31/2006 5:32:03 PM
8/31/2006 5:34:03 PM
8/31/2006 5:36:03 PM
8/31/2006 5:38:03 PM
8/31/2006 5:40:03 PM

 

[venkat1926]

Suppose your data is in A2 to A6 and some numerical data in B2 to B6
I think you date time is in text format.
Select a blank cell (really blank no formulas etc)
Edit – copy
Highlight A2 to A6
Edit –pastespecial-under operation –choose “add”
Now the columns will turn into some number with decimals
Now FORMAT a2 to a6 as date with time something like
Mm/dd/yy hh:mm AM (or PM) choose the relevant from the format for date
A2 to A6 will turn into
8/31/06 5:32 PM
8/31/06 5:34 PM
8/31/06 5:36 PM
8/31/06 5:38 PM
8/31/06 5:40 PM
See the entry will be right ended. That means they are numbers and not text
Now plot your graph.

If you want you can experiment with format x axis in scale

 

[Prhyme]

That worked for me. Thanks a lot for the help.