If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to put conditions in Excel Chart data labels?
It annoys me to see the Data Label still appears for zero value in a chart.
Is there a way to put in condition that if value is zero then do not show the Data Labels? |
#2
|
|||
|
|||
How to put conditions in Excel Chart data labels?
Use a custom number format that doesn't show zeros, for example, one of
these: $0.00;($.00);;@ 0.0%;-0.0%;;@ 0;0;;@ For more about number formats, see http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Therese" wrote in message ... It annoys me to see the Data Label still appears for zero value in a chart. Is there a way to put in condition that if value is zero then do not show the Data Labels? |
#3
|
|||
|
|||
How to put conditions in Excel Chart data labels?
Thanks Jon.
The zero value no longer shows but the Data Label is still there. Is there a way to remove the Data Label if the Value is Zero? Therese "Jon Peltier" wrote: Use a custom number format that doesn't show zeros, for example, one of these: $0.00;($.00);;@ 0.0%;-0.0%;;@ 0;0;;@ For more about number formats, see http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Therese" wrote in message ... It annoys me to see the Data Label still appears for zero value in a chart. Is there a way to put in condition that if value is zero then do not show the Data Labels? |
#4
|
|||
|
|||
How to put conditions in Excel Chart data labels?
Hi,
It sounds like the problem is that you have formatted the data labels fill or border so that they are visible. If the data labels are not formatted then suppressing the display as Jon suggested takes care of the problem. However, if the values are going to remain fixed, so 0 values will remain 0 and you don't want to see the data labels you can delete individual data labesl. Single click any data label, then single click the data label you want to remove and press Del. There is one additonal solution, you can write a VBA program that adds data labels to data points when those points are 0. You can run such a macro automatically whenever the values being plotted change. If this helps, please click the Yes button. Cheers, Shane Devenshire "Therese" wrote: Thanks Jon. The zero value no longer shows but the Data Label is still there. Is there a way to remove the Data Label if the Value is Zero? Therese "Jon Peltier" wrote: Use a custom number format that doesn't show zeros, for example, one of these: $0.00;($.00);;@ 0.0%;-0.0%;;@ 0;0;;@ For more about number formats, see http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Therese" wrote in message ... It annoys me to see the Data Label still appears for zero value in a chart. Is there a way to put in condition that if value is zero then do not show the Data Labels? |
#5
|
|||
|
|||
How to put conditions in Excel Chart data labels?
Thanks Shane.
As it's a dynamic graph template where the values change depending on the input data so I cannot delete the data items. Is it easy to write a VBA program? "Shane Devenshire" wrote: Hi, It sounds like the problem is that you have formatted the data labels fill or border so that they are visible. If the data labels are not formatted then suppressing the display as Jon suggested takes care of the problem. However, if the values are going to remain fixed, so 0 values will remain 0 and you don't want to see the data labels you can delete individual data labesl. Single click any data label, then single click the data label you want to remove and press Del. There is one additonal solution, you can write a VBA program that adds data labels to data points when those points are 0. You can run such a macro automatically whenever the values being plotted change. If this helps, please click the Yes button. Cheers, Shane Devenshire "Therese" wrote: Thanks Jon. The zero value no longer shows but the Data Label is still there. Is there a way to remove the Data Label if the Value is Zero? Therese "Jon Peltier" wrote: Use a custom number format that doesn't show zeros, for example, one of these: $0.00;($.00);;@ 0.0%;-0.0%;;@ 0;0;;@ For more about number formats, see http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Therese" wrote in message ... It annoys me to see the Data Label still appears for zero value in a chart. Is there a way to put in condition that if value is zero then do not show the Data Labels? |
Thread Tools | |
Display Modes | |
|
|