Modify Chart Legend Entries - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 PowerPoint 2010

When a chart has a legend displayed, you can modify the individual legend entries by editing the corresponding data on the worksheet. For additional editing options, or to modify legend entries without affecting the worksheet data, you can make changes to the legend entries in the Select Data Source dialog box.

What do you want to do?

• Edit legend entries on the worksheet

• Edit legend entries in the Select Data Source dialog box

Edit legend entries on the worksheet

1. On the worksheet, click the cell that contains the name of the data series that appears as an entry in the chart legend.

2. Type the new name, and then press ENTER.

   The new name automatically appears in the legend on the chart.

Edit legend entries in the Select Data Source dialog box

1. Click the chart that displays the legend entries that you want to edit.

   This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Design tab, in the Data group, click Select Data.

   

3. In the Select Data Source dialog box, in the Legend Entries (Series) box, select the legend entry that you want to change.

4. Click Edit.

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

5. In the Series Name box, do one of the following:

   • Type the reference to the worksheet cell that contains the data that you want to use as the legend entry text.

     Tip: You can also click the Collapse Dialog button  at the right end of the Series name box, and then select the worksheet cell that contains the data that you want to use as the legend entry. When you finish, click the Collapse Dialog button again to display the entire dialog box.

   • Type the legend entry name that you want to use.

     Note: When you type a new name, the legend entry text is no longer linked to data in a worksheet cell.

   • 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.

     Tip: You can also click the Collapse Dialog button  at the right end of the Series values box, and then select the data series that you want to use for the new legend entry. When you finish, click the Collapse Dialog button again to display the entire dialog box.

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×