Plot times of day on chart

B

Bruce

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
 
D

David Biddulph

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.
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top