KEMBAR78
Steps For Google Sheets in Creating Graphs | PDF | Chart | Microsoft Excel
Scribd
Upload
52 views1 page

Steps For Google Sheets in Creating Graphs

This document provides a guide for creating various types of charts in Google Sheets, including Pictogram, Heat Map, Bubble, Area, and Radar charts. Each section outlines the steps needed to input data and generate the respective chart using the Google Sheets interface. It also notes that Mekko and Sunburst charts are not supported in Google Sheets.

Uploaded by

jonisfree123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
52 views1 page

Steps For Google Sheets in Creating Graphs

This document provides a guide for creating various types of charts in Google Sheets, including Pictogram, Heat Map, Bubble, Area, and Radar charts. Each section outlines the steps needed to input data and generate the respective chart using the Google Sheets interface. It also notes that Mekko and Sunburst charts are not supported in Google Sheets.

Uploaded by

jonisfree123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

12MMF4A VCE Mathematics: Foundation Unit 3 & 4

Below is a guide in using Google Sheets in creating Graphs

Pictogram Chart: Heat Map Chart:


 Enter your data in Google Sheets (just like in  Input your data in the sheet (numbers you want
Excel). to visualize).
 Highlight the data you want to graph.  Highlight the cells containing the data you want
 Click on the ‘Insert’ menu at the top. to turn into a heat map.
 Select ‘Chart’ from the dropdown.  Click Format → Conditional formatting.
 A chart will appear (likely as a column chart by  In the Conditional format rules panel that
default). appears on the right:
 Under Format cells if, choose Color scale (this
tab is right next to the "Single color" tab).
Bubble Chart:  By default, Google Sheets shows a 3-color scale.
 Enter your data in Google Sheets (just like in You can choose preset color scales or customize
Excel). your own.
 Highlight the data range including X, Y, and Size  Select the color scale you want (for example,
columns (skip the label column if needed). green to white to red, or the second option
 Click Insert → Chart. from the list). This will color your data cells
 In the Chart Editor (right-hand side): based on their relative values.
 Under the "Setup" tab, click on the Chart type
dropdown. Area Chart:
 Scroll down and select “Bubble chart”.  Enter and highlight your data in Google Sheets
 Your chart should now display bubbles based (similar layout as Excel).
on:  Click on the Insert menu at the top.
 X-axis → Column B  Select Chart.
 Y-axis → Column C  The Chart Editor will open on the right side.
 Size of bubbles → Column D  Under the Setup tab, click on Chart type
dropdown.
Mekko Chart not supported  Scroll down to Area chart and select Stacked
area chart (usually under “Area” or “Stacked
area”).
Radar Chart:  Your chart will display as a stacked area graph,
 Enter your data in Google Sheets (just like in showing how parts contribute to the whole over
Excel). time or categories.
 Highlight the data range (skip the label column
if needed).
 Click Insert → Chart.
 In the Chart Editor (right-hand side):
 Under the "Setup" tab, click on the Chart type
dropdown.
 Scroll down and select “Radar chart”.
 Your chart should now display bubbles

Sunburst Chart not supported

Term 3 2025 Data Presentation using Google Sheets

You might also like