ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I put text in a chart legend box? (https://www.excelbanter.com/charts-charting-excel/189494-how-do-i-put-text-chart-legend-box.html)

abbeyrosess

How do I put text in a chart legend box?
 
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

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


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com