If you read how to create charts with multiple ranges of data, then your chart will also include a legend and a title. However, you might instead want a pie chart of the sales for the year 2019. What you do is to select the data to be included, and then insert a chart. What you get is the following by default:
You may have noticed that there is no title and there is no legend to the chart... How can we add it?
Step 1: Double click on the chart. A Chart Editor tab will appear on the right side.
Step 2: Click on the Customize tab, and then click on Chart & axis titles. A drop-down box would appear. Type the title on the box below Title text.
You might as well center the title by clicking on the Align icon from the left under Title format, and then select Center:
To add the legend labels, you must first make sure that the labels are on the same row as what they are describing, and are listed on the same column. To add them, here are the steps once you have reached the Chart editor:
Step 1: Click on the Setup tab, then click on the box below the Label.
Step 2: We can either type the cells containing the labels or select them. We will select the cells instead. Click on the symbol of a small rectangle divided into four parts:
Step 3: A pop-up window will appear. Select the cells containing the labels. After choosing them, press OK.
Here is our completed chart:
Looks amazing, right? We can tweak this further to get better results:
You can now make beautiful and understandable charts using Google Sheets. There is one important trick yet to be learned, especially useful when you have several sets of data being displayed at the same time.
We had this chart from the previously-linked tutorial at the top of the article:
We will now move the legend to the bottom.
At the Chart editor tab, click on the Customize tab, and then go to the Legend tab. A set of options will appear once you click on it.
If you click on the box below the Position, a drop-down box will appear containing the options for the position of the legend. Click Bottom. The Legend is now moved to the bottom of the chart.
-Add Trendline in Google Sheets
-Line of Best Fit Google Sheets
-Finding the Slope in Google Sheets
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
