how to make a pie chart in excel 2011 for mac

As shown below, the column chart for Brand B is linked to cells D2:D7.

First, we must determine the cell that contains the legend name for our chart by clicking the chart. Output: How to rename legend Change legend name The legend name is immediately changed to “A”.įigure 8. Delete the current entry “=Sheet1!$C$2” in series name and enter “ A ” into the text box. Right-click anywhere on the chart and click Select Dataįigure 4. There are two ways to change the legend name: The legend in a chart can be edited by changing the name, or customizing its position and format. The legend will then appear in the right side of the graph. From the Legend drop-down menu, select the position we prefer for the legend When we encounter an Excel chart without a legend, we can easily add a legend through these steps: Add legend to an Excel chart In the chart above, the legend is located in the top center of the graph, showing a bulleted list with text “A” and “B Sales”. Legends are automatically created everytime we create a graph or plot our data.įigure 1. The key to understanding charts is through the use of legends.

How to make a pie chart in excel 2011 for mac