| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Preceding Zero's
I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000,
2000-3000. Do you have any ideas on how to hold onto the preceding zeros so it will list right? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Preceding Zero's
Try custom formatting your axis values.
Double click a value on the axis, and format it accordingly as you would normally do in Excel itself. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "s. Dost" wrote: I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000, 2000-3000. Do you have any ideas on how to hold onto the preceding zeros so it will list right? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Preceding Zero's
You can change the format of these cells in the spreadsheet to Text.
Bear in mind this will not sort correctly in numerical order so you will need to make sure the line items are in the right order before creating your chart. Wigi wrote: Try custom formatting your axis values. Double click a value on the axis, and format it accordingly as you would normally do in Excel itself. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "s. Dost" wrote: I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000, 2000-3000. Do you have any ideas on how to hold onto the preceding zeros so it will list right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print preceding zeros in excel? | Excel Worksheet Functions | |||
| remove preceding zeros | Excel Worksheet Functions | |||
| lists dependent on preceding list selection | Excel Discussion (Misc queries) | |||
| HTML to Excel: preceding 0's disappear?! | Excel Discussion (Misc queries) | |||
| Preceding Zeros... | Excel Worksheet Functions | |||
Linear Mode
