How To Change The Name Of Series In Excel

Download PC Repair Tool to rapidly find & set up Windows errors automatically

If you lot want to rename or edit the data serial name in Microsoft Excel graph or chart without changing the row or column name, this article will be handy for you. The data series is the data that appears at the bottom of the graph or chart. Information technology can be the row or column names.

It is straightforward to create a bar graph or nautical chart, Line nautical chart, etc. in an Excel spreadsheet. When you create a graph or chart, information technology fetches data from the selected cells. Let'due south assume that y'all made a chart in an Excel spreadsheet, but you take to edit the information series proper noun.

How to rename Data Series in Excel graph or chart

To alter, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or cavalcade proper name, follow this procedure:

Open the Excel spreadsheet to detect the chart.
Select the nautical chart.
Right-click on information technology and cull the Select Data selection.
Select the information series from the Legend Entries box.
Click the Edit button.
Enter the new name in the Series proper name box.
Enter the Series values if required.
Click the OK push.

Open up the Excel spreadsheet where you tin detect the desired chart. And so, select the chart in the spreadsheet and right-click on information technology. In the context carte, you will see an pick chosen Select Data. Y'all need to click on it.

Later that, choose the data series name that you want to alter in the Legend Entries box. It appears on the left-hand side of the window. Following that, click the Edit button.

At present, remove everything from the Series name box and enter the new name that y'all desire to prove in the chart. Following that, enter the Series values if you desire to customize information technology also.

Once washed, click the OK button twice to save the change. Later on saving, the spreadsheet chart or graph will appear with the new information serial name.

In case you want to modify multiple data series names, follow the aforementioned steps. Before clicking the 2d OK button to save the change, select the next data series, and keep following the same steps equally mentioned here.

Thar's all! Hope information technology helps.

Sudip loves to engage with the latest technology & gadgets. Apart from writing nearly all things engineering science, he is a Photoshop junkie and a football game enthusiast.