The process of changing or renaming the series name should not be difficult as you will learn in thisarticle: how to change series name in Excel.
Usually, when you create a chart in Excel, it names the data series automatically. But there are some cases when you may want to change or rename the Excel Worksheet series.
By default, the names of data series in Office apps are linked to the worksheet data that are used for the chart. If you make changes to that data, they’re automatically shown in the chart.
The process of renaming or changing the series name should not be difficult as you will learn in thishow to change series name in Excel article.
How to rename a data series in Excel
If you want to give you data series in Excel a new name or change the values without changing the worksheet's data, here’s what to do:
Open your Excel Sheet/chart that you want to rename
Locate theSelect DataSourcedialog box, then navigate to underLegend Entries (Series)
In the Legend Entries,select the data series you want to rename, and clickEdit.
In theEdit Seriesdialog box,clear series name, type thenew series namein the same box, and click theOK.
The name you typed (new name) appears in the chart legend, but won't be added to the Excel worksheet.
Note: you can link theseries nameto a cell if you clear theoriginal series nameand select thespecified cell, and then click theOK.
Return to theSelect Data Seriesdialog box, and click theOKbutton to save the changes. This will change the name of the specified data series.
How to Change Series Value in Excel
To change the data range for the data series, you will follow the same process, except instead of changing theSeries Name, you’ll change theSeries Valuesin the Edit Series dialogue box.
Locate theSeries valuesbox
Type the data range for the data series or enter the values you want.
ClickOk
Note: again, the values you type will appear in the chart, but won't be added to the worksheet.
Wrapping Up
In this guide to changing Series Name in Excel, we’ve discussed how to change series names in Excel and how to change seres value in Excel. We believe it has been an insightful learning opportunity.
Are you looking for more guides or want to read more Excel and tech-related articles? Consider subscribing to our newsletter here below, where we regularly publish tutorials, news articles, and guides.
Recommended Articles
You may also like to learn more about Excel in the following articles
Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.
Select your chart and on the Chart Design tab, choose Select Data.Choose on the legend name you want to change in the Select Data Source dialog box, and select Edit. Note: You can update Legend Entries and Axis Label names from this view, and multiple Edit options might be available.
Right-click your chart, and then choose Select Data.In the Legend Entries (Series) box, click the series you want to change.Click Edit, make your changes, and click OK.
Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.
Select the Series: Select Series “Actual” in the chart. Add Data Labels: Go to the Layout tab, select Data Labels > Right. Format Data Labels: Right-click the data label, select Format Data Labels, show the Series Name, and uncheck the Value.
Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas.
The easiest way to find and replace multiple entries in Excel is by using the SUBSTITUTE function. The formula's logic is very simple: you write a few individual functions to replace an old value with a new one.
In the Replace with box, enter the text or numbers you want to use to replace the search text. Select Replace or Replace All. Tip: When you select Replace All, every occurrence of the criteria that you're searching for is replaced, while Replace updates one occurrence at a time.
Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. ...
Drag the fill handle .
If needed, click Auto Fill Options. and choose the option you want.
Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas.
Hobby: LARPing, Kitesurfing, Sewing, Digital arts, Sand art, Gardening, Dance
Introduction: My name is Amb. Frankie Simonis, I am a hilarious, enchanting, energetic, cooperative, innocent, cute, joyous person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.