When you create a chart in Excel, it uses the information in the cell above each column or row of data as the legend name. You can change legend names by updating the information in those cells, or you can update the default legend name by using Select Data.
- On the Insert tab, in the Charts group, click the Pie symbol. Click on the pie to select the whole pie. Click on a slice to drag it away from the center. Result: Note: only if you have numeric labels, empty cell A1 before you create the pie chart.
- Numbers for Mac: Add a legend, gridlines, and other chart markings in a Numbers spreadsheet You can add a legend, gridlines, and other markings to a chart to modify its look and emphasize your data. Change the look of the legend text. Except stacked charts, 2-axis charts, 3D charts, pie charts, and donut charts.
This is a continuation of Legends in Excel Charts – Formats, Size, Shape, and Position, which started a discussion about the legends in Excel charts.That article talked about legend formatting, and how the best legend is no legend at all: it’s more effective to put the text labels right on the data.
Note: If you create a chart without using row or column headers, Excel uses default names, starting with “Series 1.” You can learn more about how to create a chart to ensure your rows and columns are formatted properly.
Small Text Generator
In this article
![excel Pie Chart Legend Too Small Text \excel For Mac\ excel Pie Chart Legend Too Small Text \excel For Mac\](/uploads/1/2/6/0/126005267/147338010.png)
Printer Prints Too Small Text
Show the legend in your chart
![excel Pie Chart Legend Too Small Text \excel For Mac\ excel Pie Chart Legend Too Small Text \excel For Mac\](https://static.makeuseof.com/wp-content/uploads/2016/01/learn-excel-670x335.jpg)
- Select the chart, click the plus sign in the upper-right corner of the chart, and then select the Legend check box.
- Optional. Click the black arrow to the right of Legend for options on where to place the legend in your chart.
Change the legend name in the excel data