From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Change Legend In Excel

  • Author:
  • Published on:
    June 18, 2023
  • Category:
  • Last updated:
    July 17, 2023
  • Tags:
How To change legend in excel - step by step guide by ajelix - banner

Customizing the legend in Excel charts is a crucial aspect of creating visually appealing and informative data visualizations. This article will guide you through the process of changing the legend in Excel. Exploring various customization options, and providing best practices for creating compelling legends.

What is Legend in Excel Charts?

The legend in an Excel chart serves as a key that helps viewers interpret the data being presented. Chart Legends in chart provides you with the a visual representation of the series so you could better understand the data.

What is legend in excel definition

The screenshot represents where the legend is located in the chart

Related Article: How To Make Bar Chart Bars Wider?

What is Default Legend in Excel?

When you create a chart in Excel, it automatically generates a default legend based on the data series or categories. The default legend settings are created to provide you with a basic information about your data. They may not always align with your specific requirements.

What is the default legend generated by excel

The infographic represents how default legends are generated from the data table by Excel.

Related Article: How To Make Bar Graph in Excel

How To Rename Legend in Excel Chart?

Time needed: 3 minutes

Change Default Legend in Excel Chart

  1. Click on the chart and choose Chart Filters

    How to change default legend name in excel - step 1 - click on the chart

  2. In the additional menu choose which legend you want to edit and click Edit Series

    Change default legend name - step 2

  3. In Edit Series tab you can edit Series Name and pick the cell with the new legend name from your sheet. The new name will show up in the chart.

    How to change legend name - step 3

Related Article: How To Center Horizontally in Excel

How To Format the Legend?

Formatting the legend enhances its visual impact and improves readability. You can adjust the font style, size, and color to match your chart’s overall design and chart titles. By applying different formatting options such as bold, italics, or underline you can highlight important elements.

To edit the legend just click on it and head to Home settings to change the formatting.

Format the legend settings in excel

How To Change Legend Position in The Chart?

  1. Click on the chart sheets, additional chart settings Chart Design tab will appear;
  2. In the Excel toolbar choose Add Chart Element;
  3. Select the Legend and choose which position you want the legend to be placed;

Changing the text alignment in the legend offers three options: aligning it to the left, right, or center. You can select whichever you prefer.

How to change legend position in the chart - excel

Screenshot that includes all the steps needed to take in order to change the Legend position

Related Article: How To Delete A Chart in Excel?

How To Remove or Hide the Legend from the Chart?

In some cases, it may not be necessary to include a legend on a chart. If this is the case, it is best to remove the legend entirely.

Hiding the legend temporarily can give a clearer visual appearance. This is especially useful when you have limited space. Or the legend is not necessary for understanding the chart.

To delete the legend just select the chart, pick legend, and press the Delete key.

Related Article: How To Switch Row and Column in Excel?


This article aims to empower users. It does this by emphasizing the importance of customizing legends. It also encourages readers to explore different options. This will help them create column charts group with visually appealing and informative legends that effectively communicate their data.

Frequently Asked Questions

How do I reorder legend entries in Excel?

To reorder legend entries in Excel, you can follow these steps:
1. Right-click on any part of the chart that displays the legend.
2. Click “Select Data” from the context menu.
3. In the “Select Data Source” dialog box, click on the “Legend Entries (Series)” section.
4. Click on the dialog box. Look for the up and down arrows on the right side. Use the arrows to alter the order of the legend entries.
5. Click “OK” to apply the changes and see the updated legend order in the chart.
How to reorder legend series in excel chart. Step by step guide on how to do it

How can I change the legend symbols or icons?

To change the legend symbols or icons in Excel, you can use the following method:
1. Right-click on any part of the chart that displays the legend.
2. Select “Format Legend” from the context menu.
3. In the “Format Legend” pane, navigate to the “Legend Options” section.
4. To change the legend symbols, click on the “Legend Keys” option and choose the desired symbol style.
5. To use custom icons or images as legend symbols, click on the “Image Fill” option and select the appropriate image.
6. Adjust any additional formatting options as desired, such as size, color, or border.
7. Close the “Format Legend” pane to see the updated legend symbols or icons in the chart.

Learn more about Excel and Google Sheets hacks in other articles. Stay connected with us on social media and receive more daily tips and updates.

New Articles

Speed up your spreadsheet tasks with Ajelix AI in Excel

Excel formula generator from Ajelix - more than 15 ai tools for spreadsheets

Similar posts

How to analyze data in Excel spreadsheet banner by author

How To Analyze Data In Excel Spreadsheet

April 4, 2024
Excel is the workhorse of data analysis in countless businesses. It can unlock valuable insights from spreadsheets, but for many, its pow…
How to add drop down list in Excel banner

How To Add Drop Down List in Excel

November 2, 2023
Let’s take a look at how to add drop down list to make your spreadsheets more professional and user-friendly. We’ll take a lo…
How to add checkbox in Excel banner

How To Add Checkboxes In Excel

October 31, 2023
This article will cover steps to add checkboxes in Excel with screenshots and tips to help you tackle this task. Learn how to enable the …

Online Calculators

Free future value calculator online banner

Free Future Value Calculator Online: Calculate FV

June 13, 2024
A future value calculator helps you estimate how much an investment will be worth in the future, taking into account factors like interes…
Free IRR calculator online: calculate your internal rate of return banner

Free IRR Calculator: Calculate Internal Rate of Return

June 11, 2024
IRR formula in Excel screenshot from spreadsheet for IRR calculator
Net present value banner

Free NPV Calculator Online: Calculate Net Present Value

June 6, 2024
An NPV calculator is a tool that helps you assess the profitability of an investment by calculating its Net Present Value (NPV). Calculat…
Calculate markdown metric with free online calculator banner

Free Markdown Calculator Online

June 4, 2024
A markdown calculator is used by businesses to maximize profits. They track how much you discount inventory, helping you identify areas t…
free clt calculator: calculate customer lifetime value online banner by ajelix

Free CLV Calculator: Calculate Customer Lifetime Value

May 30, 2024
Customer lifetime value calculator, also referred to as CLV calculator or lifetime value (LTV), is a metric that businesses use to estima…
Free debt to asset ratio calculator online banner

Free Debt To Asset Ratio Calculator Online

May 28, 2024
The debt to asset ratio calculator is a tool to assess a company’s financial health by indicating the proportion of its assets fina…

Business Intelligence

Hoe to calculate business growth rate with examples and formula banner by ajelix

How to Calculate Business Growth Rate? Formula & Examples

April 16, 2024
Whether you’re a seasoned entrepreneur or just starting, measuring progress is vital to identify areas of strength, pinpoint opport…
How to calculate average revenue per user formula & meaning example banner

Calculate Average Revenue Per User: ARPU Formula & Meaning

April 11, 2024
The metrics are king, there’s no doubt about it. They tell the story of your company’s health, customer base, and overall suc…
How to calculate revenue growth in Excel with examples and formulas banner by ajelix

How To Calculate Revenue Growth Rate: Formula & Examples

April 9, 2024
Revenue growth rate is a performance indicator, that helps understand if your sales efforts are yielding positive results. Tracking it ov…
What is collaborative business intelligence (BI) and analytics blog article banner by ajelix

Collaborative Business Intelligence (BI) & Analytics

April 2, 2024
Imagine a world where everyone in your organization, from sales reps to executives, can easily access, analyze, and discuss data together…
top 7 business intelligence trends (bi) 2024 banner ajelix

7 Business Intelligence Trends (BI) 2024

March 28, 2024
This year, Business intelligence trends are all about harnessing the power of technologies like Generative AI and Natural Language Proces…
Financial business intelligence meaning and examples banner by ajelix team

Financial Business Intelligence Meaning & Examples

March 26, 2024
Measuring business financial health is vital for any manager or owner to understand what is happening in your company. However, you can’t…