Design Fraction Circles with Google Sheets

January 20, 2020

Design Fraction Circles with Google Sheets

January 20, 2020
Picture1

Did you know you can design PERFECT fraction circles in no time using Google Sheets? They are all measured out for you instantly! And it gets better…

Picture1

You can also choose any color scheme for your fraction circle clipart. AND…you can easily add labels for each section, with little work on your end!

Here are the steps...

First, open a new sheet. Here you will enter the data for the different types of fraction circles you would like to make. Name your sheet to refer to later:

Picture1

As you enter your data, each column should represent a different fraction circle. Five cells would be used for 1/5, six cells for 1/6, and so on:

Picture1

Once you have all of your data entered, you are ready to design those circles! Choose a column and select all of the cells (1/6  is shown in this example):

Picture1

With this column selected,  go to Insert and then choose Chart. You will first see a bar graph. Click the three circles on the right side and Edit Chart:

Picture1

Go to Chart Type and choose Pie (on the left-hand side, towards the bottom of the menu):

Picture1
Picture1

You will now see a pie chart like the one below. Click on any of the numbers around the chart and press delete. Now you can customize your chart.

Double-click on one of the slices. You can change your colors (If you'd like to learn more about this, please see the Custom Colors highlight on my Instagram page).

Picture1

You can make each slice of the fraction circle a different color if you would like to use it in a slideshow or as clipart for your students. Or you can make all parts the same color and leave some pieces white, to represent parts of a whole:

Picture1

To change the border colors of the fraction circle, double-click your chart. Under the menu, click on Pie Chart and then Border Color:

Picture1

I use black borders when showing a fraction circle with missing pieces…and white borders when showing a colorful fraction circle without missing parts:

Picture1

Once you have chosen the colors you would like, you will want to remove the background color and border around your fraction circle:

Picture1

Double-click on your pie chart. Under the Chart Editor, click on Customize. Set both the Background Color and Chart Border Color to none:

Picture1

If you would like to add fraction values to your circle, head into the Chart Editor again.  Under SLICE LABEL choose VALUE orPERCENTAGE.

Picture1

Each time you create a new fraction circle, repeat the steps you just followed. Your sheet will have several pie charts now.

To use these as clipart or in a presentation, create a new google slide. Then, click on INSERT, CHART, and choose FROM SHEETS.

Picture1

Choose the sheet you just made. You will see a list of all the pie charts you just designed. Select each chart you want to use and then click IMPORT.

Picture1

Now your charts will be in a google slide, all ready for you to use! If you ever want to make a change to one of the fraction circles, you will go back to the sheet. Make your changes. When you are working in your slide, you will see an update button. Click on it and the fraction circle will update with your changes!

Picture1

There are so many awesome ways to use charts in slides! Please click below to see how we use charts to track our reading in class:

No Comments

Leave a Reply

Instagram

Instagram did not return a 200.

Follow @ladybugsteacherfiles

×