How to Change Legend Colors in Excel (With Easy Steps)

The legend is a section of the chart that indicates what different colors, lines, and areas mean in the chart.

The legend always shows the color of the data series. So, to change the legend colors, you need to change the color of the series in the graph.

key takeaways

➤ Right-click on a series.
➤ Select Format Data Series from the context menu.
➤ Change the fill color in the Line section of the Fill & Line tab of the Format Data Series pane.

selecting color of the line in format pane

Before we dive into the steps, remember that this is the process of changing the color of a data series.

In this tutorial, we will cover how to change the legend colors in Excel by changing the series color.

Download Practice Workbook

Steps to Change Legend Colors in Excel

Here is the sample dataset and chart we are using for demonstration.

temperature chart of different cities

It contains temperatures across three different cities in six different months. We are presenting them with a line chart.

This is the default color for the chart that Excel creates. We will change them to a custom color.

1

Open “Format Data Series” Pane

In Excel 2016 and later versions, every formatting option is included in a different pane. This pane pops up on the right of the sheet after you select the formatting option.

In the prior versions, the options would be available in a dialog box.

To open the pane, right-click on a series and select Format Data Series from the context menu.

format data series option in the context menu


2

Select “Fill & Line” Tab

In the pane, select the Fill & Line tab.

You can find it in the form of a button of a paint bucket.

fill option in the format pane


3

Adjust Fill Color

Now select Solid, Gradient, or Automatic under the Line section. This is the line style you prefer.

Under that, you will find the Color option.

Select a color from here and the series color will change.

selecting color of the line in format pane

The legend color will also change accordingly.

legend color changing in the excel chart


FAQ

How do I change the font color of a legend?

To change the font color, right-click on the legend and select the Format Legend option from the context menu. A similar “Format Legend” pane will appear on the sheet. Under the Text options, change the fill color there.

Why doesn’t the legend color change when I change the data series color?

The legend should always change with the data series’ color. If it isn’t happening, ensure that the color change is applied correctly. Also, if you create a custom legend with text box objects, it won’t change the legend color with the data series. Since they are not linked.

How do I reset the legend colors to their default settings?

To reset the legend colors, you need to reset the series colors. To revert a series color back to normal, right-click on the series and select Reset to Match Style from the context menu.


Wrapping Up

In this tutorial, we have covered how to change legend colors in Excel. In doing so, we have demonstrated how to change the color of a data series in an Excel chart.

This is because the two are connected if the legend was created in Excel.

Feel free to download the practice file and let us know about your feedback.

ExcelInsider Team
We will be happy to hear your thoughts

Leave a reply

Excel Insider
Logo