How to rename data series in Excel chart

Data series in Excel is a collection of data displayed in a row or column shown in a chart or graph. And during data processing there will be times when you need to change the name of the data series. in the chart.

To create a chart in Excel, we need to create a data table and then, the chart will display data based on the content and data in the table. If the data table has only a few columns, you can change the name for each column or row. However, we can do it faster by editing it in the chart. The following article will guide you to rename data series in Excel.

Instructions for renaming data series in Excel

Step 1:

For example, we have the data sheet and the chart from the data table as below. We will rename the data series A, B, C and D in the chart.

Picture 1 of How to rename data series in Excel chart

We right click on the chart and select Select Data .

Picture 2 of How to rename data series in Excel chart

Step 2:

Display the new interface for us to select the data source. You click on the name A and click Edit to proceed to edit.

Picture 3 of How to rename data series in Excel chart

Step 3:

Now you need to enter a new name for the data column in Series name and then click OK below to rename this data column.

Picture 4 of How to rename data series in Excel chart

Back in the Select data table, we will see the name of a column of data that has been changed. You continue with the remaining data columns. After renaming the column, click OK below to save the new changes.

Picture 5 of How to rename data series in Excel chart

The result of the data series in the chart has been changed to another name for easier viewing of the chart.

Picture 6 of How to rename data series in Excel chart

You've just finished reading the article "How to rename data series in Excel chart" edited by the TipsMake team. You can save how-to-rename-data-series-in-excel-chart.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV Fix Printer Spooler error code 0x800706b9 on Windows 10
NEXT » Fix 'Display driver stopped responding and has recovered' error in Windows 10 / 8.1 / 7