Google sheets are great for quick visualizations and analysis. We can use it to plot data points on a graph or chart. The data in this sheet (or any other sheet) can be displayed as a line graph, bar graph, column graph, or pie chart.
Setting up the chart is simple and only takes a few steps:
- Highlight the cell range that contains the data you want to show on your chart
- Click the Insert tab and then select ‘ charts’ under the ‘ visualization’ section
- A gallery of charts will pop up. Click on a chart you would like to add to your sheet
- You can make changes or format your chart by right-clicking on it and selecting “edit” from the drop-down menu
Once you’ve selected a chart and made any necessary changes, your data will appear as an image. You can click on this image to add additional charts, edit the data or format your chart.
You can also customize your chart to add data labels to show a little more detail- Just follow these steps:
- Double click on your chart and you will see a sidebar appear with options to “Setup” or “Customize” your chart
- There are several options under “Customize” which can help your chart look more informative. You can also use this to select the color of your chart or add details such as data labels.
- To add data labels, click on “Series” as shown in the image below
- Under “Series” click on the checkbox which says “Data Labels”
- Once you do that, you will see the Sales values (in USD) appear on your chart as shown below.
Tip: Clicking on the image once you’ve inserted it into your document will open up a new window where you can edit or format the chart using built-in tools provided by google or making use of other third-party tools.
If you have a slightly larger dataset, you or your team may need to create multiple visualizations. You can do the above in 2 clicks using modern BI tools such as Conbi by just asking for the chart you want to see. It works like magic.
Learn How here.