FAQs
On the ribbon, click Chart Design and then click Select Data. This selects the data range of the chart and displays the Select Data Source dialog box. 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.
How do you change the name of a data series? ›
In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.
How do I change the series name in Excel legends? ›
- Select your chart and on the Chart Design tab, choose Select Data.
- Choose on the legend name you want to change in the Select Data Source dialog box, and select Edit. ...
- Type a legend name into the Series name text box, and click OK.
How do I edit all data labels at once? ›
On a chart, do one of the following: To reposition all data labels for an entire data series, click a data label once to select the data series. To reposition a specific data label, click that data label twice to select it.
How to rename data labels in Excel chart? ›
Change the text of the axis labels
- Click each cell in the worksheet that contains the label text you want to change.
- Type the text you want in each cell, and press Enter. As you change the text in the cells, the labels in the chart are updated.
How to rename data series in sheet? ›
Inputting the New Series Name
After selecting the "Series" or "Data labels" option, a new window will appear where you can view and edit the series names. Locate the specific series you want to rename and click on it.
How do I change a data series in Excel? ›
Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.
How do I change the legend sequence in Excel? ›
Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.
How do you customize data labels in Excel? ›
To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.
How do I change data labels in sheets? ›
Learn more about types of charts.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize. Series.
- Optional: Next to "Apply to," choose the data series you want to add a label to.
- Click Total data labels.
- Optional: Make changes to the label font.
Select the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart element. Clicking the small icons at the top of the pane moves you to other parts of the pane with more options.
How do I label a data series in Excel chart? ›
Add data labels
Click the chart, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type.
How do I rename a column label in Excel? ›
Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.
How do you rename a data model? ›
To rename a data model:
- Do one of the following: a. Right-click the data model name in the Rules Explorer view and select Rename from the context menu. ...
- In the Rename Resource dialog box, type a new name in the New name field.
- To open a list of all changes to be performed, click Preview. Important: ...
- Click OK.
How do you change the name of a data range? ›
How to edit named ranges in Excel
- Navigate to the "Formulas" tab.
- Locate "Name Manager."
- Select the named range that you want to edit.
- Type the new name in the "Name" line in the "Edit Name" box.
- Press "OK."
- Click "Close" on the "Name Manager" box.
How do I change the name of a data file? ›
Rename a file in File Explorer or OneDrive
- Open File Explorer or OneDrive.
- Right-click the file and select Rename.
- Enter a new file name and press Enter.