Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing Data Labels with 0 as blank
When selecting Values for Data Labels, is there a way to make the label
associated with a column/bar that has a zero value display as blank rather than 0? Any help would be greatly appreciated. Thanks, Bob |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing Data Labels with 0 as blank
Manually or with a formula, change the zero in the source data to a blank
("" or " "). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... When selecting Values for Data Labels, is there a way to make the label associated with a column/bar that has a zero value display as blank rather than "0"? Any help would be greatly appreciated. Thanks, Bob |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing Data Labels with 0 as blank
Jon,
I already tried your suggestion whereby if my formula evaluates to a zero, it changes the cell to "" (rather than showing zero). But the Data Label still shows "0" (rather than blank) Bob "Jon Peltier" wrote: Manually or with a formula, change the zero in the source data to a blank ("" or " "). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... When selecting Values for Data Labels, is there a way to make the label associated with a column/bar that has a zero value display as blank rather than "0"? Any help would be greatly appreciated. Thanks, Bob |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing Data Labels with 0 as blank
Then you could try a custom number format, something like this:
0;;; which will only show positive numerical values. More formats he http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... Jon, I already tried your suggestion whereby if my formula evaluates to a zero, it changes the cell to "" (rather than showing zero). But the Data Label still shows "0" (rather than blank) Bob "Jon Peltier" wrote: Manually or with a formula, change the zero in the source data to a blank ("" or " "). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... When selecting Values for Data Labels, is there a way to make the label associated with a column/bar that has a zero value display as blank rather than "0"? Any help would be greatly appreciated. Thanks, Bob |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing Data Labels with 0 as blank
That did the trick. Thanks!
"Jon Peltier" wrote: Then you could try a custom number format, something like this: 0;;; which will only show positive numerical values. More formats he http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... Jon, I already tried your suggestion whereby if my formula evaluates to a zero, it changes the cell to "" (rather than showing zero). But the Data Label still shows "0" (rather than blank) Bob "Jon Peltier" wrote: Manually or with a formula, change the zero in the source data to a blank ("" or " "). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bob" wrote in message ... When selecting Values for Data Labels, is there a way to make the label associated with a column/bar that has a zero value display as blank rather than "0"? Any help would be greatly appreciated. Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
Incorrect Data Labels on Column Chart | Charts and Charting in Excel | |||
Showing the Grand Total on Data Labels | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |