Make a LINE chart (not XY which needs numbers) with your times as the
x-values
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Cinco" wrote in message
...
I have created an X-Y scatter chart whose X-Axis has Time-of-Day (TOD)
values
from -12 (noon) to 0 (midnight) to +12 (noon following day). To make the
chart more readable, I would like to replace the X-Axis labels with their
corresponding "text" TOD. For example, 12 would be Noon, 0 would be
Midnite,
-1 would be 11PM, +1 would be 1AM. Is there a way to do this? Thanks.
Jim