Plot times of day on chart
 

I have a time series that i want to plot where the independant variable is a
time of day which i think is a text format.

eg. 10:30:31 AM

When I plot this on the x-axis it plots as a cateogry instead on a time,
hence the data points to not have the spacial relation of the time of day.

What do I need to do to plot my dependant variable Y against X which is a
time of day?

Bruce

Plot times of day on chart
 

What type of chart are you using? Have you tried XY chart?

If your data is text rather than being a number, you might be able to change
it either by adding zero with paste special/ add, or multiplying by 1 with
paste special/ multiply. Another option worth looking at is Data/ Text to
columns. If you've got spurious spaces or non-printable characters in your
text you may need to remove them.
--
David Biddulph

"Bruce" wrote in message
...
I have a time series that i want to plot where the independant variable is
a
time of day which i think is a text format.

eg. 10:30:31 AM

When I plot this on the x-axis it plots as a cateogry instead on a time,
hence the data points to not have the spacial relation of the time of day.

What do I need to do to plot my dependant variable Y against X which is a
time of day?

Bruce

Plot times of day on chart
 

If you are asking how to change the Text representation of a time into a
real time then try:

Copy an unused cell and then highlight the text *times* and then Paste
Special Add. This should turn the text into numbers.

If it does not then there are probably other hidden characters in the cell.
With a *time* in say G3, compare =LEN(G3) with the apparent number of
characters in the cell remembering that a space is still a character. Post
back if you need further help.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bruce" wrote in message
...
I have a time series that i want to plot where the independant variable is
a
time of day which i think is a text format.

eg. 10:30:31 AM

When I plot this on the x-axis it plots as a cateogry instead on a time,
hence the data points to not have the spacial relation of the time of day.

What do I need to do to plot my dependant variable Y against X which is a
time of day?

Bruce