| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Getting rid of labels showing zero values
I have a chart with labels showing the values of the source cells. When the
value of a source cell is zero, I dont want the label to show anything at all (not zero). If the source cell is empty it works fine. So then I use the IF command take make the source cell empty if the value is zero, but that doesnt work for some reason as long as the source cell is a summary of other cells, the chart labels keeps on showing zero. Any solution for this? -- Lars |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Getting rid of labels showing zero values
Hi,
You could change the number format of the data labels to General;General; which will not display the zero Cheers Andy Lars wrote: I have a chart with labels showing the values of the source cells. When the value of a source cell is zero, I dont want the label to show anything at all (not zero). If the source cell is empty it works fine. So then I use the IF command take make the source cell empty if the value is zero, but that doesnt work for some reason as long as the source cell is a summary of other cells, the chart labels keeps on showing zero. Any solution for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing Data Labels with 0 as blank | Charts and Charting in Excel | |||
| How can I change labels to a table for showing menu choices | Excel Discussion (Misc queries) | |||
| Column Labels (A, B) are showing us as numbers (1,2). Please Help | Excel Worksheet Functions | |||
| Showing the Grand Total on Data Labels | Excel Discussion (Misc queries) | |||
| Excel chart data labels showing % change instead of value? | Charts and Charting in Excel | |||
Linear Mode
