I have 1470 lines of data with the Date and time on different cells. It looks
like this:

A1: Fri Feb 13, 2004
A:2 5:00 PM

it goes all the way down to A:1470. I have tried to separate the time from
the date by making two columns (A: date B:time) but that doesn't work either.


"David Biddulph" wrote:

If your combined date and time is in A2, use =MOD(A2,1) to get just the
time, and use that as the X-axis series for your chart.
--
David Biddulph

"hollis78" wrote in message
...
I am trying to create a chart from a spreadsheet of data that has 3 years
and
all 12 months. Each month has different days and different times where
data
was pulled. What I want to do is create a chart with all the months in the
data and have the axis showing time intervals of an hour each starting
from
12:00am-12:00am with the hours in between 12:00am, 1:00am, etc). Can
anyone
help me? I have tried using the scale under the format axis tab but can't
figure out how to show time in intervals. Thanks.