How To Change Legend Names In Google Sheets

How to add text & label legend in Google Sheets [Full guide]

Matthew is a freelancer who has produced a diverseness of manufactures on various topics related to technology. His main focus is the Windows OS and all the things surrounding it. He is passionate most... Read more

Adding graphs to your Google Sheets spreadsheets volition enhance their visual appeal but these aren't particularly defined with no fable labels.
This guide tells you how users can add legend labels to Google Sheet graphs and format the text for them.
Our Teamwork department includes more than guides for Google apps and other squad collaboration software.
You can also scan through how-to manufactures for numerous web apps at our Web & Cloud hub.

TenINSTALL BY CLICKING THE DOWNLOAD FILE

Sheets is Google's alternative to Microsoft Excel. The Sheets web app is freely available to all Google account users.

Although information technology might lack some of Excel's features, Sheets is however a pretty good alternative.

Like all spreadsheet applications, Sheets enable users to ready upwards charts for data entered. To make Sheets graphs clear, yous must add legend labels to them.

The legends will show what data the graphs brandish.

How tin can I add text & format legend in Google Sheets?

1. Add a label fable

Commencement, enter the data for your graph across a column or row in a Google Sheets spreadsheet.
Hold the left mouse button and drag the cursor over the data entered to select it.
Click Insert > Nautical chart to add the graph to the sail.
Click the Nautical chart type drop-down menu to select i of the pie graph types to add a label legend to.
Click in the Add Label box, and select the cell range that includes your chart data. Then the chart will brandish the data value labels similar the i in the snapshot directly below.
Y'all can remove the characterization fable past deselecting the Employ column as labels checkbox.

ii. Edit text in a legend

To edit legend label text, double-click a label on the chart. Double-clicking one characterization volition select all of them and open up the options shown directly below.
Double-clicking a fable label a second time volition open up a small-scale text box with which you tin can change the label's text.
You can select an culling font for the labels by clicking the Legend font driblet-down menu on the Chart editor sidebar.
Click the B and I button in the Text style box to apply bold and italic formatting for all the labels.
Click the Text color box to cull an alternative text color.
Y'all click the Legend font size drop-downwardly carte du jour to increase or decrease the text size for all labels.

3. Edit the legend labels' positioning

To change legend positioning, click the Customize tab on the Nautical chart editor'southward sidebar.
Click Fable to expand further options.
So select either Top, Bottom, Left, or Right in the Position drib-downwardly menu to modify the legend to one that doesn't display percentage value labels for pie charts.
Double-click a specific value within the legend to select it.
Then you can apply specific text formatting to the selected value with the options on the Nautical chart Editor's sidebar.

And then, that's you tin can add and edit label legends in Google spreadsheet graphs. The information labels those legends brandish are essential to charts.

If you found this data useful, or y'all would like to add some other suggestions to this guide, delight feel costless to employ the annotate section found below this article.