Rename a data series

The names of data series in apps for Office 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 rename an existing data series or change the values 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

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.