Thread: How do I put text in a chart legend box?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default How do I put text in a chart legend box?
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

abbeyrosess wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote