Change Series Name Excel Mac

Select the formulas tab of the ribbon.

Change series name excel mac. Select the range you want to name including the row or column labels. On the excel menu click preferences. Right click anywhere on the chart and click select data figure 4. Select the name manager icon in the middle of the ribbon to open the name manager.

Rename a data series in an excel chart. Now the select data source dialog box comes out. Change series name in select data step 1. Please click to highlight the specified data series you will rename and then.

In the create names from selection dialog box designate the location that contains the labels by selecting the top row left column bottom row or right column check box. The name you type appears in the chart legend but won t be added to the worksheet. You can update legend entries and axis label names from this view and multiple edit options might be available. In the select data source dialog box under legend entries series select the data series and click edit.

Type a legend name into the series name text box and click ok. Right click your chart and then choose select data. Right click the chart with the data series you want to rename and click select data. Click on the legend name you want to change in the select data source dialog box and click edit.

Figure 7 excel series name change change the value of a series if we want to change the data range for our data series we will enter the new range for the data or enter the values manually. We will right click on the chart with the data series we which to rename. Click edit make your changes and click ok. In the name manager select the new button to open the new name dialog box.

In the series name box type the name you want to use. Select formulas create from selection. Changes you make may break links to the source data on the worksheet. Quickly enter a series of numbers or text and number combinations.

Right click the chart whose data series you will rename and click select data from the right clicking menu. The complete list of steps are as follows.