If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie Chart Question
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. |
#2
|
|||
|
|||
Pie Chart Question
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" wrote: 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. |
#3
|
|||
|
|||
Pie Chart Question
Yes, that helped.
Many thanks - mo yes button in Outlook Express I'm afraid! Regards. Bill. "Shane Devenshire" wrote in message ... 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" wrote: 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. |
#4
|
|||
|
|||
Pie Chart Question
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" wrote: Yes, that helped. Many thanks - mo yes button in Outlook Express I'm afraid! Regards. Bill. "Shane Devenshire" wrote in message ... 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" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|