How to Rename Series in Excel (Series, Legends & Axis Titles)

When you create a chart in Excel, the data series is named automatically. You might occasionally need to change the name of the data series for personal or professional reasons. In this blog post, you will learn how to rename series in Excel.


Download Practice Workbook

You can download the practice workbook from the following download button.


3 Suitable Examples to Rename Series in Excel

Excel provides a few options for renaming data series. We have created a dataset with the column titles Year, Global Inflation (%), and Average Closing Price of Oil ($) to demonstrate this. The sample data set is shown below:

sample data set: Rename Series in Excel


1. Rename a Data Series in Excel

By editing the dataset, especially the column headings that serve as the chart’s legends, we may change the legends. The following dataset and chart, where the columns are Year, Worldwide Inflation (%), and Average Closing Price of Oil ($), is what we’re going to use. These legends require new names.

📌 Steps:

  • To choose data, use the right-click menu to select the chart whose data series you want to rename. See illustration:

use the right-click menu to select the chart to Rename Series in Excel

  • A Select Data Source dialog box appears at this point. Please choose the data series that you want to rename by clicking upon that, and then select the Edit option. See illustration:

A Select Data Source dialog box appears

  • Feel free to delete the previous series name from the Edit Series dialog box before typing the new series name inside the Series name field and clicking the OK option. See illustration:

typing the new series name inside the Series name field to rename

  • Note that the legend name has been changed to Inflation only like the image below.

legend name has been changed to Inflation

Read More: How to Rename a Workbook in Excel (4 Easy Methods)


2. Rename Series Legends by Double Clicking on Them

We may rename the legends by editing the dataset, especially the column headings that serve as the chart’s legends.

📌 Steps:

  • To begin, double-click the D4 cell and alter Oil Price ($) as the column header.
  • Next, key in ENTER.
  • At some point, we’ll notice that the chart’s initial legend has been modified to read Oil Price ($).

double-click the D4 cell and alter Oil Price ($) as column header

Read More: How to Rename a Sheet Without Using Mouse in Excel (2 Ways)


3. Rename Axis Title of a Series

Sometimes, you may not have legends or axis titles when you first create the graph from the data. We are going to show the necessary steps in the following steps:

📌 Steps:

  • Firstly, we will select the data and then click on the Plus sign beside the chart. After that select the preferred option according to your project.

click on the Plus sign beside the chart

  • Notice in the image that, we have added the % and $ signs by editing the Axis Title like the image below.

added % and $ sign by editing the Axis Title


Conclusion

Follow these steps and stages to understand the topic of how to rename a series in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, i am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo