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 %?