Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stop excel changing chart axes labels when letters are repeated
I use the 1st character of each month as axes labels. When a character is
repeated excel automatically adds a 2 or 3 suffix. Excell may be confused but I'm not. How do I stop it. Formatting the cells as text in excell and setting that attribute for the chart axes hasn't helped. Thank you |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stop excel changing chart axes labels when letters are repeated
I have never seen this behavior in Excel. Just to be sure, I tested it
before this post. In three cells I entered "J" and in adjacent cells some numbers. Excel did not append numbers to the J's. Then, I plotted the range as a chart. Each of the 3 labels on the x-axis is "J". Do you by any chance have some kind of add-in (or workbook code) that provides enhanced charts or some kind of support for charts? If so, you might want to look at that for possible causes. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Leslie Haas" wrote: I use the 1st character of each month as axes labels. When a character is repeated excel automatically adds a 2 or 3 suffix. Excell may be confused but I'm not. How do I stop it. Formatting the cells as text in excell and setting that attribute for the chart axes hasn't helped. Thank you |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stop excel changing chart axes labels when letters are repeated
"Look in Tools/Options for the "Spelling" tab. Click on a button called
"AutoCorrect Options" in the lower left-hand corner. You will find a set of check boxes which will turn off the auto-fill functions "Leslie Haas" wrote: I use the 1st character of each month as axes labels. When a character is repeated excel automatically adds a 2 or 3 suffix. Excell may be confused but I'm not. How do I stop it. Formatting the cells as text in excell and setting that attribute for the chart axes hasn't helped. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move axes and axis labels behind data points on scatter chart | Charts and Charting in Excel | |||
how to keep data labels in chart in 2007 from changing? | Charts and Charting in Excel | |||
How do I change the grid axes to #'s and letters? | Excel Discussion (Misc queries) | |||
How do I change the grid axes to #'s and letters? | Excel Discussion (Misc queries) | |||
How do i stop the colors changing on my pivot chart when i refres. | Excel Discussion (Misc queries) |