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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

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

×