| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hiding Pie Slice When Value is Zero
My data labels contain the Value and Percentage. I can hide the Value of a
slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hiding Pie Slice When Value is Zero
Why not just filter the data (showing only 0) and use the entire
(unfiltered) range as source data. The chart will not show hidden values - only the filtered values. Sandy "Bob" wrote in message ... My data labels contain the Value and Percentage. I can hide the Value of a slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hiding Pie Slice When Value is Zero
Sandy,
Thanks for the suggestion. Unfortunately, since I have selected the Percentage checkbox for Data Labels (which I need to show), Excel still shows "0%" when the pie slice's value is zero. What I'm trying to figure out is how to not have the "0%" be displayed and the corresponding pie slice not displayed when the pie slice's value is zero. Bob "Sandy" wrote: Why not just filter the data (showing only 0) and use the entire (unfiltered) range as source data. The chart will not show hidden values - only the filtered values. Sandy "Bob" wrote in message ... My data labels contain the Value and Percentage. I can hide the Value of a slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hiding Pie Slice When Value is Zero
Bob
I have tried setting up a Pie Chart in the way you are describing with the "Percentage" checkbox selected in Data Labels and it works fine for me (unless I am at total cross purposes). Have a look here http://www.webstruct.co.uk/webstruct...t/PieChart.xls I have uploaded the simple chart I tested. Sandy "Bob" wrote in message ... Sandy, Thanks for the suggestion. Unfortunately, since I have selected the Percentage checkbox for Data Labels (which I need to show), Excel still shows "0%" when the pie slice's value is zero. What I'm trying to figure out is how to not have the "0%" be displayed and the corresponding pie slice not displayed when the pie slice's value is zero. Bob "Sandy" wrote: Why not just filter the data (showing only 0) and use the entire (unfiltered) range as source data. The chart will not show hidden values - only the filtered values. Sandy "Bob" wrote in message ... My data labels contain the Value and Percentage. I can hide the Value of a slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hiding Pie Slice When Value is Zero
Sandy,
Thanks. I see what you did. However, I was hoping to accomplish the same thing automatically without any manual intervention (or macros). Bob "Sandy" wrote: Bob I have tried setting up a Pie Chart in the way you are describing with the "Percentage" checkbox selected in Data Labels and it works fine for me (unless I am at total cross purposes). Have a look here http://www.webstruct.co.uk/webstruct...t/PieChart.xls I have uploaded the simple chart I tested. Sandy "Bob" wrote in message ... Sandy, Thanks for the suggestion. Unfortunately, since I have selected the Percentage checkbox for Data Labels (which I need to show), Excel still shows "0%" when the pie slice's value is zero. What I'm trying to figure out is how to not have the "0%" be displayed and the corresponding pie slice not displayed when the pie slice's value is zero. Bob "Sandy" wrote: Why not just filter the data (showing only 0) and use the entire (unfiltered) range as source data. The chart will not show hidden values - only the filtered values. Sandy "Bob" wrote in message ... My data labels contain the Value and Percentage. I can hide the Value of a slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hiding Pie Slice When Value is Zero
Have you tried setting the format to Custom, with '0%;;;' (three semicolons
following the formatting)? This is for the data labels only and will hide the 0% values you are referring to. I am having a similar issue that I cannot solve. I am trying to keep data labels that have blank values from showing up in the chart. I also would like to do this automatically as the data I am using can change frequently. I have two columns but not every row with a name in column A has a value in column B. The cells are blank, and those that fall into this category still show up in the pie chart as name-only. Because I have my formatting set as described above there are no 0% values showing up, but I cannot figure out how to get a non-value label to not show up without deleting it manually. Does anyone know of a way this can be done? "Bob" wrote: Sandy, Thanks. I see what you did. However, I was hoping to accomplish the same thing automatically without any manual intervention (or macros). Bob "Sandy" wrote: Bob I have tried setting up a Pie Chart in the way you are describing with the "Percentage" checkbox selected in Data Labels and it works fine for me (unless I am at total cross purposes). Have a look here http://www.webstruct.co.uk/webstruct...t/PieChart.xls I have uploaded the simple chart I tested. Sandy "Bob" wrote in message ... Sandy, Thanks for the suggestion. Unfortunately, since I have selected the Percentage checkbox for Data Labels (which I need to show), Excel still shows "0%" when the pie slice's value is zero. What I'm trying to figure out is how to not have the "0%" be displayed and the corresponding pie slice not displayed when the pie slice's value is zero. Bob "Sandy" wrote: Why not just filter the data (showing only 0) and use the entire (unfiltered) range as source data. The chart will not show hidden values - only the filtered values. Sandy "Bob" wrote in message ... My data labels contain the Value and Percentage. I can hide the Value of a slice (when its value=0) when I set its format to ;000. But I can't figure out how to not display the slice since the data label Percentage still shows up as 0%. Any help would be greatly appreciated. Thanks, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use different colors to show compoents of a pie slice | Charts and Charting in Excel | |||
| Changing pie chart slice colors | Charts and Charting in Excel | |||
| Pie Chart with other charts representing each slice | Charts and Charting in Excel | |||
| Pie in pie chart - how do you change the angle of the 1st slice | Charts and Charting in Excel | |||
| Pie Chart - "Other" Slice | Excel Discussion (Misc queries) | |||
Hybrid Mode
