You can manually fully edit the text in a Google Sheets legend. Press on the Text color box to choose an alternative text color. Click the B and I buttons in the Text style box to apply bold and italic formatting for all the labels.Ħ. Double-clicking a legend label a second time will open a small text box with which you can change the label’s text.ĥ. 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.Ĥ. D ouble-click a label on the chart that you want to change and go to the Customise tab.ģ. Add and edit text in a Google Sheets legendġ. You can remove the label legend by deselecting the Use column as labels checkbox.Ģ.Then the chart will display the data value labels like the one in the snapshot directly below. Click in the Add Label box, and select the cell range that includes your chart data.Click the Chart type drop-down menu to select one of the pie graph types to add a label legend to.Click Insert > Chart to add the graph to the sheet.Hold the left mouse button and drag the cursor over the data entered to select it.First, enter the data for your graph across a column or row in a Google Sheets spreadsheet.How can I label legends in Google Sheets? 1. Read on to find out how to add text to a legend in Google Sheets. The legends will show what data the graphs display. To make Sheets graphs clear, you must add legend labels to them. Like all spreadsheet applications, Sheets enable users to set up charts for data entered. The Sheets web app is freely available to all Google account users.Īlthough it might lack some of Excel’s features, Sheets is still a pretty good alternative. Sheets is Google’s alternative to Microsoft Excel. Home › How to › How to add text & label legend in Sheets

How to insert text box in google sheets