| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing numeric X-axis labels with corresponding text string
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string to Numeric string | Excel Discussion (Misc queries) | |||
| Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
| Remove Numeric from a Text String - Help? | Excel Discussion (Misc queries) | |||
| Replacing characters in numeric text strings and SUMming | Excel Discussion (Misc queries) | |||
| XL 2003: Replacing X-Axis Labels with Custom Ones... | Charts and Charting in Excel | |||
Threaded Mode
