A abbeyrosess May 30, 2008 #1 I know how to make a pie chart, but instead of numbers in the legend, I want what the color represents. How do I do that?
I know how to make a pie chart, but instead of numbers in the legend, I want what the color represents. How do I do that?
A Andy Pope May 31, 2008 #2 Hi, The information displayed in the legend comes from the information provided in the Categories range. Right click chart and pick Source Data. On the series tab enter the range containing the description in the Category Label: box. Cheers Andy
Hi, The information displayed in the legend comes from the information provided in the Categories range. Right click chart and pick Source Data. On the series tab enter the range containing the description in the Category Label: box. Cheers Andy