Although it might lack some of Excel’s features, Sheets is still a pretty good alternative. Like all spreadsheet applications, Sheets enable users to set up charts for data entered. To make Sheets graphs clear, you must add legend labels to them. The legends will show what data the graphs display. Read on to find out how to add text to a legend in Google Sheets.

How can I label legends in Google Sheets?

1. Add a label legend

2. Add and edit text in a Google Sheets legend

  1. Double-click a label on the chart that you want to change and go to the Customise tab.

  2. Navigate to the Legend section.

  3. You can select an alternative font, as well as a different font size for the labels by clicking on the drop-down menu beneath Legend font.

  4. Double-clicking a legend label a second time will open a small text box with which you can change the label’s text.

  5. Click the B and I buttons in the Text style box to apply bold and italic formatting for all the labels.

  6. Press on the Text color box to choose an alternative text color.

You can manually fully edit the text in a Google Sheets legend. Its font size, font type, color and formatting can be easily modified via the built-in Chart editor.

3. Edit the legend labels’ positioning

So, that’s you can add and edit label legends in Google spreadsheet graphs. The data labels those legends display are essential to charts. If you found this information useful, or you would like to add some other suggestions to this guide, please feel free to use the comment section found below this article.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ