Donate SIGN UP

Labels in Excel

Avatar Image
Kos | 16:46 Thu 12th Oct 2006 | Technology
4 Answers
In Excel there is an option to display 'Show label and percent' but not 'Show label and value'
Can this be done?
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by Kos. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
Sorry- don't know how you edit a question.
Meant to say 'In a pie-chart'.......
Double click your pie chart and then select the data labels tab. What you want is there.
Question Author
'Fraid not Machecoul.
That gives me the same options as in my original question.
I want 'Label and Value' NOT 'Label and Percent'
Having correctly read question I have managed to do what you want I think.

I clicked the show values tab and then when I clicked on the shown value I could type next to the value i.e put in the value - so I got e.g. Green 23 / Red 15 etc.
Not the same as doing it automatically but depends what you want it for.
Any use?

1 to 4 of 4rss feed

Do you know the answer?

Labels in Excel

Answer Question >>