| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Chart (excel 2003)
How do I hide the 0% of the pie chart so that they only show the relevant %?
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pie Chart (excel 2003)
If you mean on the pie then double click the data labels and choose the
Number tab, choose Custom and enter the following code on the Type line on the right: 0%;[=0]""; -- Cheers, Shane Devenshire "Xueling" wrote: How do I hide the 0% of the pie chart so that they only show the relevant %? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pie Chart (excel 2003)
Thanks! It does look better.
But is there a way to not show the data lable of those 0% as well? "ShaneDevenshire" wrote: If you mean on the pie then double click the data labels and choose the Number tab, choose Custom and enter the following code on the Type line on the right: 0%;[=0]""; -- Cheers, Shane Devenshire "Xueling" wrote: How do I hide the 0% of the pie chart so that they only show the relevant %? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
| Excel 2003 Column Chart | Charts and Charting in Excel | |||
| How can I get Speedometer chart in MS Excel 2003? | Excel Discussion (Misc queries) | |||
| Column chart excel 2003 | Charts and Charting in Excel | |||
| How can I export an excel 2003 chart to a .jpg? | Charts and Charting in Excel | |||
Hybrid Mode
