View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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 %?