In this tutorial, you will learn how to change a series name in Google Sheets
How To Change Series Name In Google Sheets
If you have a Google Sheets chart that contains a legend, you may want to change the name of one or more of the series in the legend. For example, you may want to rename “Series 1” to “Budget” and “Series 2” to “Actual”.
In this guide, we will show you how to change the name of a series in a Google Sheets chart legend. We will also explain how to activate the legend if it still needs to appear on the chart.
How To Rename a Series in Google Sheets Chart
Here’s how to rename a series in a Google Sheets chart.
First, select the Google Sheets chart you want to edit.
In this example, we have a bar chart that tracks the monthly product sales of three different items. Our goal is to add a legend to the chart and later modify the names of each series.
After selecting the chart, you may click on the Customize tab in the Chart editor. Click on the Legend option to expand the section.
Choose a position from the drop-down list. The legend will automatically appear in the desired position.
In our example, we have three products :Product A, Product B, and Product C. To change these values, double-click on the legend text.
The legend text should now change into a textbox. Remove the existing text and add your desired series name. Hit the Enter key to apply the new series name.
Proceed to perform the previous step on the remaining legend items.
This guide should be everything you need to change the series name in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.