Pie Chart Question

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I have a pie chart where I want to show values on the chart, but the values
blend together on the small slices and look a mess. Is there any way to not
show the data values when they are less that a certain proportion of the
whole chart? Or any other way of doing the same?

Thanks for any help.
Bill.
 
Hi,

1. Select the data labels and choose Format, Selected Data Labels
2. Activate the Number tab and choose Custom.
3. Enter the following custom format to the Type box
[>60]0.00;;

Adjust the >60 as needed it means that all values 60 and below will not
display.
 
Yes, that helped.
Many thanks - mo yes button in Outlook Express I'm afraid!
Regards.
Bill.

Shane Devenshire said:
Hi,

1. Select the data labels and choose Format, Selected Data Labels
2. Activate the Number tab and choose Custom.
3. Enter the following custom format to the Type box
[>60]0.00;;

Adjust the >60 as needed it means that all values 60 and below will not
display.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


Bill said:
Hi All,

I have a pie chart where I want to show values on the chart, but the
values
blend together on the small slices and look a mess. Is there any way to
not
show the data values when they are less that a certain proportion of the
whole chart? Or any other way of doing the same?

Thanks for any help.
Bill.
Click to expand...
Click to expand...
 
Hi,

Glad to help, no problem with the Yes button, that is a web interface option.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


Bill said:
Yes, that helped.
Many thanks - mo yes button in Outlook Express I'm afraid!
Regards.
Bill.

Shane Devenshire said:
Hi,

1. Select the data labels and choose Format, Selected Data Labels
2. Activate the Number tab and choose Custom.
3. Enter the following custom format to the Type box
[>60]0.00;;

Adjust the >60 as needed it means that all values 60 and below will not
display.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


Bill said:
Hi All,

I have a pie chart where I want to show values on the chart, but the
values
blend together on the small slices and look a mess. Is there any way to
not
show the data values when they are less that a certain proportion of the
whole chart? Or any other way of doing the same?

Thanks for any help.
Bill.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top