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?
Add Chart Title
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:
Add Legend Labels
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.
Changing the Position of the Legend
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.
Suscribe to get more data and analytics tips!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.