| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hide data labels with "0" values
Some of my source data contains cells with "0" values that I don't want to
show on my chart. How can I get them to now show up? I need to leave those cells in my source data range as I am working with a spreadsheet that is updated monthly so as to automatically update the chart. -- Karen |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hide data labels with "0" values
How about a custom format like 0.0;-0.0;""
Right click a data label on chart and select Format Data Labels best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Roachie" wrote in message ... Some of my source data contains cells with "0" values that I don't want to show on my chart. How can I get them to now show up? I need to leave those cells in my source data range as I am working with a spreadsheet that is updated monthly so as to automatically update the chart. -- Karen |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hide data labels with "0" values
Thanks Bernard! I was able to get it to work by using the custom format of
0.0;-0.0; This sight is awesome! -- Karen "Bernard Liengme" wrote: How about a custom format like 0.0;-0.0;"" Right click a data label on chart and select Format Data Labels best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Roachie" wrote in message ... Some of my source data contains cells with "0" values that I don't want to show on my chart. How can I get them to now show up? I need to leave those cells in my source data range as I am working with a spreadsheet that is updated monthly so as to automatically update the chart. -- Karen . |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hide data labels with "0" values
Thanks for the feedback
Bernard "Roachie" wrote in message ... Thanks Bernard! I was able to get it to work by using the custom format of 0.0;-0.0; This sight is awesome! -- Karen "Bernard Liengme" wrote: How about a custom format like 0.0;-0.0;"" Right click a data label on chart and select Format Data Labels best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Roachie" wrote in message ... Some of my source data contains cells with "0" values that I don't want to show on my chart. How can I get them to now show up? I need to leave those cells in my source data range as I am working with a spreadsheet that is updated monthly so as to automatically update the chart. -- Karen . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide "Show details" when right click on data field in Pivot Table | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Show / hide data by seeing if a field says "Yes" | Excel Discussion (Misc queries) | |||
| How to hide "Send To Mail Recipient" data? | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
