How To Rename A Data Series In Microsoft Excel
24/9/19 Series Name Series Name is obviously the name of the series, and it's what is displayed in a legend This argument is usually a cell reference, Sheet1!$F$2, but it can also be a hardcoded string enclosed in double quotes, "alpha", or it can be left blank If it is blank, the series name will be "Series N ", where N is the number of the seriesHowever, Excel has a limitation where the data series name, if specified, must refer to a cell within the table (usually one of the headers) To workaround this Excel limitation you can specify a user defined name in the table and refer to that from the chart
