Replacing numeric X-axis labels with corresponding text string

C

Cinco

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
 
B

Bernard Liengme

Make a LINE chart (not XY which needs numbers) with your times as the
x-values
best wishes
 
C

Cinco

Bernard,

My data necessitates an XY Scatter chart - I am plotting events that occur
at uneven intervals during a time period (typically 8hrs). All my charting
is complete.

What I now want to do is, exchange (or map) each x-axis label (numeric -12
to +12) with a text string where -12 & =+12 would be "noon", 0 would be
"midnight". I've read some other folks' posts (with responses from Jon
Peltier & others) that hint that this may be doable (maybe with a table
Lookup or a dummy X-Axis). Thanks.
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top