How To Change Series Name In Excel Mac 2011

How to rename a data series in an Excel chart?

In general, the data serial will be named automatically when you creating a nautical chart in Excel. In some cases, yous may need to rename the information series equally below screenshot shown, how could y'all handle it? This article volition bear witness you the solution in detail.

Rename a information series in an Excel chart

Rename a information series in an Excel chart

To rename a data series in an Excel nautical chart, please do equally follows:

i. Right click the chart whose data serial yous will rename, and click Select Data from the right-clicking card. Come across screenshot:

2. Now the Select Information Source dialog box comes out. Please click to highlight the specified data serial yous will rename, and and then click the Edit push button. Come across screenshot:

iii. In the Edit Series dialog box, please articulate original series proper name, type the new series proper noun in the Series name box, and click the OK push. See screenshot:

Annotation: If you want to link the series name to a cell, please articulate original series name and select the specified jail cell, and so click the OK button.

4. At present yous return to the Select Data Serial dialog box, please click the OK push to save the change.
At nowadays, yous can see the specified data series has been renamed. See screenshot:

You can echo the to a higher place steps to rename other data serial as yous need.

The Best Office Productivity Tools

Kutools for Excel Solves Nigh of Your Problems, and Increases Your Productivity by 80%

Reuse: Quickly insert complex formulas, charts and anything that you take used earlier; Encrypt Cells with password; Create Mailing Listing and send emails...
Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Foreclose Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Observe and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Bank check Boxes and more...
Excerpt Text, Add Text, Remove by Position, Remove Space; Create and Impress Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (salve and apply filter schemes to other sheets); Avant-garde Sort by calendar month/week/24-hour interval, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than than 300 powerful features. Supports Function/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or system. Full features 30-day free trial. 60-day coin back guarantee.

kte tab 201905

Part Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Give-and-take, Excel, PowerPoint , Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity past 50%, and reduces hundreds of mouse clicks for you lot every day!

officetab bottom