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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing numeric X-axis labels with corresponding text string
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing numeric X-axis labels with corresponding text string
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 "Bernard Liengme" wrote: 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 |
Reply |
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 |