In this tutorial article, I will show you how to add charts to your Google Sheets, how to edit the legend that Google Sheets assigns to your charts, and how to edit some other chart features.
How To Add a Chart and Edit the Legend in Google Sheets
Working with charts is relatively simple. You just need to have a set of data to refer to, design a chart in the built-in charting tool within Sheets, set the legend so it is easily understandable, and insert it into the spreadsheet. You can create your own data to follow this tutorial, or you can create a new sheet and use the data I use for my examples. To create a chart, we first need to specify a data set for the chart to be based on. We begin by selecting a data range and working from there.
Different chart types lend themselves well to displaying different data types. Not all chart types will work with all data, so it may be a case of experimenting as you go along. Each type of standard chart has an associated type of information that it is best-suited for displaying, depending on what the visualization is intended to accomplish.
For example, in the case of our monthly household expenses, a pie chart is a very powerful way to demonstrate that our mortgage payment is dominating our monthly expenses because it makes that visual element very large on the sheet. The chart legend is the colored box and text that tells the reader what each color on the chart represents.
Formatting the Chart Legend (Mac)
Change your legend's font and font size. You can select a custom font and change the size of all the text here. Click the Legend font drop-down. Select a font to use.
Click the Legend font size drop-down. Select or manually enter a font size.
- how to move a page in word 2011 mac.
- Related Topics.
- Video of the Day.
Select a color for the text in the legend. Here you can select a color and change all the text in your chart's legend. Click the Text color menu to see all your color options. Select a color to apply it. Chart title and legend title can be automatically generated from the corresponding blank cell of the sheet.
Make sure you check the box "Use row 1 as headers" in the chart property page. Yes No. Not Helpful 2 Helpful 0.
Change the font, size, or style of text
I think the easiest way to do that is to add whatever you want the title to be in the cell above your data. Make sure it's highlighted with the data, and make sure "Use x as headers" is clicked. Not Helpful 5 Helpful 0. Unanswered Questions. How do I get my legend on Google Sheets to show I'm using the same data in a chart twice? Answer this question Flag as Flag as How do I edit a legend so it's in numerical order?
Was this information helpful?
How do I change the words in Google Sheets? Include your email address to get a message when this question is answered.
- Change legend names.
- system requirements bioshock infinite mac!
- How to Add a Legend on Excel for Mac | It Still Works?
Already answered Not a question Bad question Other. Related wikiHows. Article Summary X 1. Did this summary help you? Article Info This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.
Numbers for iCloud: Edit chart text, markings, and labels
Is this article up to date? Can you please put wikiHow on the whitelist for your ad blocker? Learn how. Cookies make wikiHow better.