How to Change the Legend on Google Sheets (PC or Mac)

Table of contents:

How to Change the Legend on Google Sheets (PC or Mac)
How to Change the Legend on Google Sheets (PC or Mac)
Anonim

This wikiHow teaches you how to customize a chart legend on a Google Sheets spreadsheet using a desktop browser.

Steps

Edit the Legend on Google Sheets on PC or Mac Step 1
Edit the Legend on Google Sheets on PC or Mac Step 1

Step 1. Open Google Sheets using a browser

Type sheets.google.com in the browser address bar and press Enter on your keyboard.

If the login is not automatic, enter your e-mail address or telephone number, click on "Next", enter your password and then click on "Next" again

Edit the Legend on Google Sheets on PC or Mac Step 2
Edit the Legend on Google Sheets on PC or Mac Step 2

Step 2. Click on the spreadsheet you want to edit

Look for the spreadsheet in the list of files you saved and open it.

Edit the Legend on Google Sheets on PC or Mac Step 3
Edit the Legend on Google Sheets on PC or Mac Step 3

Step 3. Click on the chart you want to edit in the spreadsheet

This will select it and a blue outline will appear around it.

Edit the Legend on Google Sheets on PC or Mac Step 4
Edit the Legend on Google Sheets on PC or Mac Step 4

Step 4. Click on the ⋮ icon

It is located in the upper right corner. The options associated with the chart will appear next to it.

Edit the Legend on Google Sheets on PC or Mac Step 5
Edit the Legend on Google Sheets on PC or Mac Step 5

Step 5. Click Edit Graph

The graphic editor will open on the right side of the screen.

Edit the Legend on Google Sheets on PC or Mac Step 6
Edit the Legend on Google Sheets on PC or Mac Step 6

Step 6. Click on the Customize tab

This button is located next to the "Configuration" tab at the top of the editor menu. The chart customization options will be displayed.

Edit the Legend on Google Sheets on PC or Mac Step 7
Edit the Legend on Google Sheets on PC or Mac Step 7

Step 7. Click on the Legend tab on the list

This will allow you to customize the legend settings.

You can change the position, font, format and color of the legend

Edit the Legend on Google Sheets on PC or Mac Step 8
Edit the Legend on Google Sheets on PC or Mac Step 8

Step 8. Click on the Position drop-down menu on the editing panel

This will allow you to select a location for the chart legend.

Edit the Legend on Google Sheets on PC or Mac Step 9
Edit the Legend on Google Sheets on PC or Mac Step 9

Step 9. Click on the location you want to select

This will change the position of the legend in the chart.

  • For the position of the legend it is possible to choose between "Above", "Below", "Left", "Right", "Inside" or "None".
  • If you select "None", the chart will not show any legend.
Edit the Legend on Google Sheets on PC or Mac Step 10
Edit the Legend on Google Sheets on PC or Mac Step 10

Step 10. Change the font and font size of the legend

You can select a custom font and change the size of all text.

  • Click on the "Legend font" drop-down menu;
  • Select a character to use;
  • Click on the "Legend font size" drop-down menu;
  • Select or enter the font size manually.
Edit the Legend on Google Sheets on PC or Mac Step 11
Edit the Legend on Google Sheets on PC or Mac Step 11

Step 11. Select a color for the text in the legend

In this section you can select a color and edit all the text within the legend.

  • Click on the "Text Color" menu to see all the color options;
  • Select a color to apply it.

Recommended: