A data series in Microsoft Excel is a set of data, shown in a row or a column, which is presented using a graph or chart. To help analyze your data, you might prefer to rename your data series. Show Rather than renaming the individual column or row labels, you can rename a data series in Excel by editing the graph or chart. You might want to do this if your data labels are opaque and difficult to immediately understand. You can rename any data series presented in a chart or graph, including a basic Excel bar chart. RELATED: How to Make a Bar Chart in Microsoft Excel To demonstrate, we have a basic bar chart showing a list of fruit sales on a quarterly basis. The chart shows four bars for each product, with the bars labeled at the bottom—these are your data series. In this example, the data series are labeled alphabetically from A to D. Labels such as these wouldn’t be hugely helpful for this example purpose, as you wouldn’t be able to determine the periods of time. This is where you’d look to rename the data series. To do this, right-click your graph or chart and click the “Select Data” option.
The Best Tech Newsletter Anywhere Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. By submitting your email, you agree to the Terms of Use and Privacy Policy. This will open the “Select Data Source” options window. Your multiple data series will be listed under the “Legend Entries (Series)” column. To begin renaming your data series, select one from the list and then click the “Edit” button. In the “Edit Series” box, you can begin to rename your data series labels. By default, Excel will use the column or row label, using the cell reference to determine this. Replace the cell reference with a static name of your choice. For this example, our data series labels will reflect yearly quarters (Q1 2019, Q2 2019, etc). You could also replace this with another cell reference if you prefer to use labels that are separate from your data. This will ensure that your chart updates automatically if you decide to change the labels shown in those cells at a later date. Once you’ve renamed your data series label, click “OK” to confirm. This will take you back to the “Select Data Source” window, where you can repeat the steps for each data series label. If you want to restore your labels to the same as your column or row labels, repeat the steps above, replacing the static labels with the cell reference for each column or row label. You will need to name the worksheet containing the label when you do this. For instance, using =Sheet1!$B$1 here would show the label in cell B1. For this example, this would show the letter A. This will mean that any changes to your column or row labels will also update the data series labels in your chart or graph. Once you’ve renamed all of the data labels, click “OK” to save the changes. Your graph or chart will show your updated data series labels. These are shown at the bottom of your chart, and are color-coded to match your data. You can make further changes to the formatting of your graph or chart at this point. For instance, you could add a trendline to your Microsoft Excel chart to help you see further patterns in your data. RELATED: How to Work with Trendlines in Microsoft Excel Charts
This tutorial will demonstrate how to change Series Names in Excel and Google Sheets. Change Chart Series Name in ExcelStart with your GraphIn this tutorial, we’ll show a Bar Graph comparing items sold for two different products by month. Let’s say instead of showing Product A and Product B on the graph, you want to show the actual series on the graph. Changing Series Name
Note: You will see the Series (Product A and Product B), which correlate to the legend on the graph. 3. For each Series, Click Edit Note: You can see right now it is linked to a current cell. Right now, it is linked to “Product A” 4. You can change this formula and link it to another cell Final Graph with Series Name ChangeAfter changing both Series Names, the final graph should look like this. Change Chart Series Name in Google SheetsSimilar to Excel, you can see the graph with the generic series names on the graph and a table
Final Graph with ChangesAs you can see, the final graph shows the updates with the new series names. |