How To Add A Legend To A Chart In Excel - Business Computer Skills

0 Item added to cart ×

Search For Courses

Search ×

Shopping Cart

Your cart is empty.

×

Your Account

Login

×

Contact By Phone

877-442-3915

Contact By Email

Send ×

Your Account

Login

×

Contact By Phone

877-442-3915

Contact By Email

Send 877-442-3915 Contact SP Login Account 0 Cart Item added to cart

• Home
• Courses Popular Topics A+ Adobe AutoCad CISA CISSP Excel In-Design Illustrator Microsoft Office Network+ Power Automate Power BI Security+ SharePoint Teams Course By Vendor (A–J) Adobe AutoDesk Agile & Scrum AWS Camtasia CompTIA CISCO CITRIX Crystal Reports EC-Council Google IBM Isaca ISO/IEC (ISC)2 Java Juniper Course By Vendor (M–W) Microsoft Office Microsoft Technical MySQL Oracle Palo Alto PMI Python QuickBooks RedHat SAS Salesforce Sketchup Splunk SQL Server Tableau VMware Wordpress Course By Topic Agile & Scrum Analytics & Data Application Dev Artificial Intelligence AutoDesk Blockchain Business Analysis Business Applications Business Intelligence Cloud Computing Cyber Security Data Management DevOps Networking/Wireless Programming Project Management Virtualization Web Development
• Services Instructor Led Training Group Training On Demand Training
• Blog Certifications Tutorials Career Guides
• Locations
• Contact

Special Offer - 25% Off - Microsoft Office On-Demand Value Pack

Over 25 Courses Included - Unlimited Repeats - 12 Month License only $149

Learn Excel, Word, PowerPoint, Teams, Access, Outlook, OneNote and Windows

Home » Courses » Excel » Excel Tutorials » Ultimate Guide To Excel Charts and Graphs » How to Add a Legend to a Chart in Excel

How to Add a Legend to a Chart in Excel

How to Add a Legend to a Chart in Excel

When creating a chart in Excel, you may want to add a legend to your chart so the users better undertand the information contained in the chart. This tutorial will teach you how to add and format a legend on your Excel chart.

Step 1: Click on a blank area of the chart

Use the cursor to click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted. Once you see the border appear around the chart, then you know it is ready to be changed.

Step 2: Click on the Chart Elements button next to the chart

Once the chart name area is highlighted, you will see the Chart Elements button next to upper right hand side of the chart. The button looks like a plus sign. Doing this will open the Chart Elements window.

Step 3: Select Legend from the Chart Elements window

Once you have opened the Chart Elements window, you will see a number of items you can select to add to your chart. Check the Legend option on the Chart Elemnts window and a Legend will appear on your chart. You can click on the arrow next to the Legend for some additional placement options for the legend.

Step 4: Position the Legend on your Chart

Once you have turn on the Legend option, you can place the legend at various positions on the chart. Click on the arrow to the right of the Legend checkbox on the Chart Elements window and you will see options for the legend placement on the chart. You are able to position your chart Legend in the following ways:

• Right
• Left
• Top
• Bottom

Step 5: Format your Chart Legend

You can open the Format Legend panel to access a number of formatting options for your chart Legend. Click on the arrow to the right of the Legend checkbox on the Chart Elements window and you will see the "More Options" button. Click on this button and the Format Legend panel will appear.

This is a list of some of the Legend formatting options available on the Format Legend panel:

• Legend Fill
• Legend Borders
• Legend Shadow
• Legend Glow
• Legend Soft Edges
• Text Fill
• Text Outline
• Text Shadow
• Text Glow
• Text Soft Edges
• Text Box Formatting

Topic #7How to Add and Remove Gridlines in Excel Charts

Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Excel Chart tutorials, or consider taking an Excel class with one of our professional trainers.

Guide Topics

• How to Make a Chart or Graph in Excel
• How to Change the Chart Type in Excel
• How to Move and Resize Charts in Excel
• How to Change the Chart Style in Excel
• How to Add a Title to a Chart in Excel
• How to Add a Legend to a Chart in Excel
• How to Add and Remove Gridlines in Excel
• How to Add Axis Labels to a Chart in Excel
• How to Make Data Tables in Excel
• How to Filter Charts in Excel
• How to Make Trendlines in Excel Charts
• How to Make Dual Axis Charts in Excel
• How to Create Chart Templates in Excel
• How to Create Sparklines in Excel
• What Types of Chart Does Excel Offer?
• Clustered Column Chart
• Line Graph
• Pie Chart
• Clustered Bar Chart
• Area Chart
• Scatter Chart
• Filled Map Chart
• Stock Chart
• Surface Chart
• Radar Chart
• Treemap Chart
• Sunburst Chart
• Histogram Chart
• Pareto Chart
• Box and Whisker Chart
• Waterfall Chart
• Funnel Chart
• Combo Chart

"The Instructor made class truly interesting and put everything into real world terms."- Meredith T(Jersey City, NJ)

×

Request a Training Quote

Tell us a bit about your team and goals—we’ll send options and pricing.

First Name * Last Name * Email * Phone * Location (City/State) Course / Topic * # of Students Select an option 1 Student 2-5 Students 6-12 Students 12-18 Students More than 18 Students Additional Details * Send Your Quote Request

By submitting this form you agree to be contacted about training options. We respect your privacy.