Rename a data series

The names of data series are typically linked to the worksheet data that's used for the chart, and changes you make to that data are automatically shown in the chart. If you want to change the name and values of existing data series without changing the data on the worksheet, do the following:

  1. Right-click the chart with the data series you want to rename, and click Select Data.

  2. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.

    Select Data Source dialog box

  3. In the Series name box, type the name you want to use.

    Edit Series dialog box

    The name you type appears in the chart legend, but won't be added to the worksheet.

  4. To change the data range for the data series, in the Series values box, type a data range for the data series or enter the values you want.

    The values you type will appear in the chart, but won't be added to the worksheet.

    Note: An xy (scatter) has a Series X values and Series Y values box, and a bubble chart has a Series X values, Series Y values, and Series bubble sizes box. You can change the data range for each of those values.

See Also

Change the data series in a chart

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!