Change the data series in a chart

Edit or rearrange a series

1. Right-click your chart, and then choose Select Data.

   

2. In the Legend Entries (Series) box, click the series you want to change.

3. Select Edit, make your changes, and select OK.

   Changes you make may break links to the source data on the worksheet.

4. To rearrange a series, select it, and then select Move Up  or Move Down .

You can also add a data series or remove them in this dialog box by clicking Add or Remove. Removing a data series deletes it from the chart—you can't use chart filters to show it again.

If you want to rename a data series, see Rename a data series.

Filter data in your chart

Let's start with chart filters.

1. Select your chart.

2. Select the Chart Filters button next to the chart.

3. On the Values tab, check or uncheck the series or categories you want to show or hide.

4. Select Apply.

5. If you want to edit or rearrange the data in your series, choose Select Data, and then follow steps 2-4 in the next section.

Edit or rearrange a series

1. Select the chart.

2. On the Chart Design tab, choose   Select Data.

   This selects the data range of the chart and displays the Select Data Source dialog box.

3. To edit a legend series, in the Legend entries (series) box, click the series you want to change. Then, edit the Name and Y values boxes to make any changes.

   Note: Changes you make may break links to the source data on the worksheet.

4. To rearrange a legend series, in the Legend entries (series) box, click the series you want to change and then select the   up or down  arrows.

Filter data in your chart

1. In Word and PowerPoint: Select your chart and on the Chart Design tab, select Edit Data in Excel.

   In Excel, select the category title and then on the Home tab, select Sort & Filter and choose Filter.

2. Select the drop-down arrow to choose the data to show, and deselect the data you don't want to show.