How to change series name in excel?

Posted on 28-02-2020 , by: admin , in , 0 Comments

How to change series name in excel?

Name 1
5
10
20
30
Problem I need to change Series name for chart, without changing or adding it to the worksheet. Question How do I change series name? Solution(step by step) 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. The name you type appears in the chart legend, but won’t be added to the worksheet.

Example:

“Name 1” is the name of the series. Inside Chart 2 (on the right) change the name of the series to “New name”. When you do that, the name of the series in chart 1 (on the left) should stay “Name 1”.
Name 1
5
10
20
30
share:

Leave a comment