How to Create a Legend in Excel Without a Chart (3 Steps)

When dealing with Excel Charts, users usually insert Chart Legends using Chart’s options. However, in some cases, users need to create a legend in Excel without a Chart or Chart’s options.

Watch Video – Create a Legend in Excel Without a Chart

Let’s say we have Actual Monthly Sales data and Projected data. We want to create a legend without using the Excel Chart or its options. And the outcome should look like the below picture.

Direct Legend-How to Create a Legend in Excel without a Chart

This article demonstrates the step-by-step process of creating a legend in Excel without a Chart.

Excel Chart’s Legend and Its Insertion

A typical Chart’s Legend creation is pretty simple using Excel Chart options. If users have an inserted chart as shown in the below image,

Just click within the Chart area. The side menu appears.

Click on the Plus Icon, and Chart Elements appear.

Tick on Legend; the Chart differentiates the inserted lines with an identification known as the Legend.

Legend-How to Create a Legend in Excel without a Chart

Make sure you tick the Data Labels option to display each point. This is important because Data Labels are going to be used to directly insert Chart’s Legend in this article.

Go through the following steps to create or add Legends without Charts in Excel.

Step 1: Inserting Dummy Values to Create a Legend Without a Chart in Excel

Add a helper column adjacent to the dataset. Copy the immediate cell values and paste them into the helper column cells as shown in the image below.

Dummy Value

🔼 Insert a Line Chart > Display the Chart Elements (by clicking on the Plus Icon). You see, the Legend option is unticked, and the Chart displays no Legend whatsoever.


🔼 Click on the Chart then expand the Data Source range up to the dummy cells. You see, straight lines are added to the pre-existing lines, as depicted in the picture below.

Expanding Data Source

Step 2: Custom Formatting Dummy Values as Legend Names

Place the cursor on the dummy value cells (here H4 and H5) and press CTRL+1 or right-click. The Format Cells or the Context Menu appears. In the case of the Context Menu, click Format Cells among the options. In the Format Cells window, select the Number section > Custom as Category > Type “Actual” (2nd time “Projected”) under Type > Click OK.

Format Cells-How to Create a Legend in Excel without a Chart

🔺 So, the final depiction of the dataset will be similar to the image below.

Formatted Data

Step 3: Inserting a Chart with Direct Legends in Excel

As the inserted Chart has expanded the Data Source (expanded in the first step), Excel automatically creates the Legend identifying the Lines without using the Chart’s option.

Direct Legend-How to Create a Legend in Excel without a Chart

🔺 If you want to cross-check the situation, just click on the Chart > click on the Plus Icon that appears in the Side Menu > you will see the unticked Legend option. That verifies the inserting of the Legend without using Chart in Excel. Keep in mind that here the Data Labels option is used to create a Legend within the Chart. Make sure you tick the Data Labels option from the Chart Elements.


Read More: How to Reorder Legend Without Changing Chart in Excel

Download Excel Workbook


In this article, we demonstrate the step-by-step process in order to create a legend in Excel without a Chart. We use the Data Labels option available in the Chart Elements to display the Chart’s Legend without a Chart. We hope this method satisfies your quest and helps you achieve your goal. Comment if you have further inquiries or have anything to add.

Related Articles

<< Go Back To Legend in Excel Chart | Excel Chart Elements | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF