Dates Don't Display Properly in Charts

Prhyme

New Member
Joined
May 12, 2006
Messages
4
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]
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
how is the date and time entered in the date column.
canyou send three or four examples of these entries.
 

Prhyme

New Member
Joined
May 12, 2006
Messages
4
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

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,652
Messages
5,660,138
Members
418,552
Latest member
Idiocracy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top