How to change series name in excel?
I need to change Series name for chart, without changing or adding it to the worksheet.
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.