In this article, you will learn how to insert a pie chart in Google Sheets.
See below how to build a pie chart with an example set of data - Sales & Marketing Expenses. Let’s assume you want to show the breakdown of the Sales & Marketing Expenses by expense category such as Salary and Advertisement. The expenses' names and the items' amounts correspond to “Label” and “Value”, respectively. The percentage attached to the chart is automatically calculated, so you don’t need to compute by yourself before you create a chart.
As you can see, the chart is almost done. Let’s make a couple of minor changes to this pie chart. Assume you want to change the chart title and the background of the chart, and make the background of the chart black.
See the two screenshots below for your reference.
This is one of the examples to customize your chart.
See the following pictures for your reference.
We recommend that you gather the information you want to visualize in a sheet to avoid an incorrect cell reference and increase the visibility of the data source of the chart. If you still need to insert a chart with data from multiple sheets for some reason, that is not difficult. You need to select a range of data in other sheets when you choose or add a range of data. Make sure that the selected fields correspond.
It is easy. After inserting a graph, select another chart pattern in the “Chart” type section. You can learn how to create other basic charts in the following articles.
How to Make a Column Chart in Google Sheets
How to Make a Waterfall Chart in Google Sheets
How to Make a Line Chart in Google Sheets
How to Make a Stacked Column Chart in Google Sheets
How to Make a Bubble Chart in Google Sheets
Are you interested in creating a customized KPI dashboard reflecting your data in real time? Check LiveFlow and the following template with graphs.
Here is an example of how charts are utilized for data sharing and reporting.
You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides
Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇