![]() Links to these tutorials are in the list below.ĭon’t miss out a great opportunity to learn: #CHANGE THE SERIES TITLE IN EXCEL FOR MAC HOW TO#To see more on how to insert or edit various chart elements, check out more Eas圜lick Academy tutorials. So, in the table, cell C2 states ‘Sales’, but the legend reads ‘Monthly Sales’, just as we wanted. Type ‘ Monthly Sales’ directly in the field, click on OK and then OK again, and that’s it! Here we’ll focus on the left-hand side of the window and click on ‘ Sales’, then on ‘ Edit’.Īnother pop-up window appears and we can see that the ‘ Series name’, which is the legend name, points out to what we’ve got stored in the cell C2.īut if needed, we can change this value to anything else. You’ll see a pop-up window where you can easily edit the information from the legend. To do this, click on the chart, then find the tab ‘ Chart Design’ and go for the option ‘ Select Data’. This way is particularly useful if you need to change the legend name to ‘Monthly Sales’ but keep the text ‘Sales’ in the table header, so basically, you change the information in the chart without changing it in the table. Let’s undo the changes and revert the ‘Monthly Sales’ to ‘Sales’ and let’s have a look at the second way how you can rename the legend in the chart. Second Way How You Can Rename a Legend in the Chart However, if this seems to be a little inconvenient, there’s another way to do it. ‘Monthly Sales’ now appears in the table and in the chart legend, too. #CHANGE THE SERIES TITLE IN EXCEL FOR MAC UPDATE#This graph shows sales, so if I rewrite the text ‘Sales’ in C2 and type in ‘ Monthly Sales’ instead, the legend will update automatically. To rename a legend in a chart, you can simply rewrite the data stored in the table that was used to create the graph. ![]() The Easiest Way How to Rename a Legend in an Excel Chart ![]() So, here’s the first one, the easiest way. ![]() Today, we’re gonna talk about the way to change the legend name. To check out that tutorial, have a look at the link in the list below. In one of our previous tutorials, you could see a more detailed way how to add a legend in an Excel chart. 2 Second Way How You Can Rename a Legend in the Chart ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |