Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Series How to changes the name of a series – Excelchat

How to changes the name of a series – Excelchat

We can change the name of series for any chart or rename an existing data series in our chart without altering the data in its worksheet. In this tutorial, we will learn how to change or edit a series name without changing our worksheet data.

Figure 1 – How to change a series name

How to Rename Series

  • We will right-click on the chart with the data series we which to rename

Figure 2 – How to rename series

    • Next, we will select Data

 

  • In the Select Data Source dialog box, we will select Edit under the Legend Entries (Series)

 

Figure 3 – how to name a series in excel

  • We will see the Series name box

Figure 4 – Changing the series name in the Edit Series dialog

  • In the Series name box, we will enter the name we wish to use.

Figure 5 – Rename series

  • Our series name change in this section will not alter our worksheet.

Figure 6 – How to change the series name

  • We will click OK

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

Figure 8 – Edit values or range of a series

  • Next, we will select Data
  • In the Select Data Source dialog box, we will select Edit, under the Legend Entries (Series).
  • We will click inside the Series Values box and highlight the new data range

Figure 9 – How to change the data series in excel

  • We can also change the name of the series

Figure 10 – How to change the series name

  • We will click OK to go back to the Select Data Source dialog Box

Figure 11 – How to edit the series name in excel

  • Finally, we will click OK to see the modified chart

Figure 12 – How to name a series in excel

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc