January 20, 2020
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…
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:
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:
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):
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:
Go to Chart Type and choose Pie (on the left-hand side, towards the bottom of the menu):
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).
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:
To change the border colors of the fraction circle, double-click your chart. Under the menu, click on Pie Chart and then Border Color:
I use black borders when showing a fraction circle with missing pieces…and white borders when showing a colorful fraction circle without missing parts:
Once you have chosen the colors you would like, you will want to remove the background color and border around your fraction circle:
Double-click on your pie chart. Under the Chart Editor, click on Customize. Set both the Background Color and Chart Border Color to none:
If you would like to add fraction values to your circle, head into the Chart Editor again. Under SLICE LABEL choose VALUE orPERCENTAGE.
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.
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.
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!