How to edit legend text in excel mac

To add a new legend entry, click Add , or to remove a legend entry, click Remove.

Type the reference to the worksheet cell that contains the data that you want to use as the legend entry text. When you finish, click the Collapse Dialog button again to display the entire dialog box. When you type a new name, the legend entry text is no longer linked to data in a worksheet cell.

How to edit legend in Microsoft excel

To add a new legend entry, type the reference to the worksheet cell or type a new name and then, in the Series values box, type a reference to the data series on the worksheet that you want to use for the new legend entry. Expand your Office skills.


  • Formatting the Chart Legend (Mac) | ERC.
  • What do you want to do?.
  • ecoutez rmc info sur mac!
  • windows remote desktop mac lion.
  • How can I change the legend text in a chart without changing the text - Microsoft Community.

Get new features first. Was this information helpful? Yes No. Any other feedback? How can we improve it?

Change legend names

To access the Legend Options panel, start by clicking your chart to select it. Click the "Charts" tab on the ribbon, click "Chart Layout," click the "Legend" button, and then click "Legend Options" to load a list of customizable options for your legend.


  • alle freunde einladen facebook firefox mac.
  • mercurial mac os x mavericks.
  • best web browser for mac os x mountain lion!

Click the "Font" tab to customize the font. Click the "Placement" tab to change where the legend appears on the chart. Warning Information in this article applies to Excel for Mac.

Modify axis gridlines

It may vary slightly or significantly with other versions or products. References 3 Microsoft: Create a Chart Microsoft: Change a Chart University of San Francisco: Information Technology Services: Excel Intermediate for Mac. About the Author Andrew Tennyson has been writing about culture, technology, health and a variety of other subjects since Accessed 19 February Tennyson, Andrew.


  1. Add a legend.
  2. comment pirater un mot de passe wifi sur mac.
  3. How to Add a Legend on Excel for Mac | It Still Works.
  4. How to Add a Legend on Excel for Mac.