How to rename data series in Excel chart
To create a chart in Excel, we need to create a data table and then, the chart will display data based on the content and data in the table. If the data table has only a few columns, you can change the name for each column or row. However, we can do it faster by editing it in the chart. The following article will guide you to rename data series in Excel.
Instructions for renaming data series in Excel
Step 1:
For example, we have the data sheet and the chart from the data table as below. We will rename the data series A, B, C and D in the chart.
We right click on the chart and select Select Data .
Step 2:
Display the new interface for us to select the data source. You click on the name A and click Edit to proceed to edit.
Step 3:
Now you need to enter a new name for the data column in Series name and then click OK below to rename this data column.
Back in the Select data table, we will see the name of a column of data that has been changed. You continue with the remaining data columns. After renaming the column, click OK below to save the new changes.
The result of the data series in the chart has been changed to another name for easier viewing of the chart.
You should read it
- How to draw a map chart on Excel
- How to create 2 Excel charts on the same image
- How to draw a pie chart in Excel 2016
- Instructions on how to create charts in Excel professional
- How to draw charts in Excel
- Instructions for creating interactive charts in Excel with INDEX function
- How to draw flow charts in Excel
- Create Excel charts that automatically update data with these three simple steps
- How to create charts in excel 2007 is extremely simple!
- How to fix chart position in Excel
- Instructions for creating charts in Excel 2007
- Use Sparklines in Excel
Maybe you are interested
How to get data from web into Excel
What information does a VPN hide? How does it protect your data?
How to transfer data between 2 Google Drive accounts
6 Data Collecting Apps You Need to Delete for Better Privacy
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data