How to make a pie chart in google sheets

Access Google Sheets:

Visit the Google Sheets website (sheets.google.com) and log in with your Google account if you're not already signed in.

Input Your Data:

Within a blank spreadsheet, enter the data you wish to represent in your pie chart. For example, if your goal is to illustrate expense distribution, categories like "Housing," "Food," "Transportation," and "Entertainment" with their respective values might be included.

Select Your Data:

Utilize your mouse to click and drag, highlighting the data you intend to incorporate into the pie chart. Be sure to select both the category labels and their corresponding numerical values.

Incorporate the Chart:

With the data highlighted, navigate to the top menu and click "Insert," followed by "Chart."

Adjust Chart Settings:

Further tailor your chart by modifying various parameters in the Chart Editor. This includes adding a chart title, modifying colors, and fine-tuning the legend and labels.

Download or Share:

To save the chart as an image, right-click on it and choose "Download." Alternatively, for collaboration or sharing purposes, use the "Share" option located in the upper right corner of your Google Sheets document.

If you want to create insightful charts with just a prompt, use this new tool on www.magicchart.io to create them, Here is a simple use case on what it can do it.

Step 1: Access the Charting Tool

Open the website click_here

Step 2: Input the prompt

Create a table where you enter the data for the top 5 search engines in the world. You will typically have two columns: one for the search engine names (categories) and another for their respective market shares (values or percentages).

Step 3: Select Data and Chart Type

Highlight the data you entered in the table. This is usually done by clicking and dragging over the cells.

Go to the charting tool's menu or toolbar and find the "Insert Chart" or similar option.

Choose the chart type suitable for displaying your data. In this case, a "Pie Chart" or "Donut Chart" is a common choice for illustrating market share.

Hit Generate Chart!

Step 4: Customize the Chart

After inserting the chart, you can customize it to enhance its appearance and clarity.

Add labels, a title, and a legend to make the chart more informative.

Adjust colors, fonts, and styles to match your preferences or branding.

Step 5: Finalize and Export

Review your chart to ensure accuracy and visual appeal.

Save or export the chart in your desired format (e.g., image file or within your document/presentation).

How to make a pie chart in google sheets

Share on socials

About the author

Create Presentations in Seconds

Create Stunning Presentations with AI in Seconds ✨