Loading...

Creating a pie chart on a spreadsheet
Key Stage 2
Year 6
Computing
In this clip, I'm gonna show you how to insert a pie chart. We're using this spreadsheet that we've used before. It's got my Items, my Spending type, my Cost, my Quantity, and my Subtotal. And we've used formulas to work out the subtotal. I've also got my Attendees, my Budget per person, and my Total budget using a formula. So, to insert a pie chart, you need to highlight some information, and we are gonna use this table as our information. So, we've got our Party items and our Overall party costs. I'm gonna click and highlight that until I get down to Budget left over. I don't want my Total party cost or my Party cost per person in my pie chart, so I'm not gonna select that. I then go to my toolbar and click Insert, and Chart, and it'll insert a pie chart for me. Now, the first thing I'm gonna do is move the pie chart around and make it slightly bigger. And then I'm gonna change the font size for my title by clicking on my title and changing my font size. Let's go for 24. And for my chart legend or my labels, I'm gonna change the font size also to 24. Now on the pie chart, you can change things round. If I want to change the colour of a certain sector, I'm gonna double-click on the sector, I can go over to the right-hand side to customise my colour, and I can also change the style of my chart. I can change the background colour if I wanted to, the border colour, I could make it 3D. I could add in a donut hole on the right-hand side here. I can change the title. So, this is Izzy's party. I'm gonna make that bold. Now, one of the benefits of using a pie chart on a spreadsheet, let's just make it smaller so you can see, is that if any of my costs change, my pie chart will automatically update. So, keep an eye out. Let's say my venue cost actually gets more expensive. So, instead of costing 150 pounds in cell C2 here, let's say it doubles in cost, so is now 300 pounds. I'm changing the cost, we've still only got one of them. The subtotal will update. And as soon as I press Enter, I think our Venue total sector will get bigger. So, let's have a look. Let's press Enter. Notice how my venue cost now is the largest sector of my pie chart. Let's change it back to 150. Let's say my party games and price increased in costs from 20 pounds to 50 pounds. I'm gonna change that and press Enter. And you can see, my Activity total sector gets larger here.
Creating a pie chart on a spreadsheet
Key Stage 2
Year 6
Computing
In this clip, I'm gonna show you how to insert a pie chart. We're using this spreadsheet that we've used before. It's got my Items, my Spending type, my Cost, my Quantity, and my Subtotal. And we've used formulas to work out the subtotal. I've also got my Attendees, my Budget per person, and my Total budget using a formula. So, to insert a pie chart, you need to highlight some information, and we are gonna use this table as our information. So, we've got our Party items and our Overall party costs. I'm gonna click and highlight that until I get down to Budget left over. I don't want my Total party cost or my Party cost per person in my pie chart, so I'm not gonna select that. I then go to my toolbar and click Insert, and Chart, and it'll insert a pie chart for me. Now, the first thing I'm gonna do is move the pie chart around and make it slightly bigger. And then I'm gonna change the font size for my title by clicking on my title and changing my font size. Let's go for 24. And for my chart legend or my labels, I'm gonna change the font size also to 24. Now on the pie chart, you can change things round. If I want to change the colour of a certain sector, I'm gonna double-click on the sector, I can go over to the right-hand side to customise my colour, and I can also change the style of my chart. I can change the background colour if I wanted to, the border colour, I could make it 3D. I could add in a donut hole on the right-hand side here. I can change the title. So, this is Izzy's party. I'm gonna make that bold. Now, one of the benefits of using a pie chart on a spreadsheet, let's just make it smaller so you can see, is that if any of my costs change, my pie chart will automatically update. So, keep an eye out. Let's say my venue cost actually gets more expensive. So, instead of costing 150 pounds in cell C2 here, let's say it doubles in cost, so is now 300 pounds. I'm changing the cost, we've still only got one of them. The subtotal will update. And as soon as I press Enter, I think our Venue total sector will get bigger. So, let's have a look. Let's press Enter. Notice how my venue cost now is the largest sector of my pie chart. Let's change it back to 150. Let's say my party games and price increased in costs from 20 pounds to 50 pounds. I'm gonna change that and press Enter. And you can see, my Activity total sector gets larger here.