![]() ![]() In the next part, you'll see how to add the viewing figures to the pie chart segments. The chart will then look like this (your labels may well be at the bottom, though, depending on which version of Excel you have):īut it looks pretty good for just a few mouse clicks! We can still do a bit more to it, though. If you haven't got this style, select a similar one, such as style 4 in Excel 2013 and Excel 2016. Each box tells which color represents which grade. Like the small grade icons at the bottom of the chart above. This adds a quick color key to the pie chart that tells which color represents what. We've gone for the second one, Style two. Select the chart > Click on the Plus Icon on the top right of the chart > Add Legends. To get different colours, make sure that your chart is selected and locate the Chart Style panel:Ĭlick the down arrow to the right of the Chart Style panel to reveal the available styles : Notice how all the segments of the pie chart are the same colour in Excel 2007:.Move your new pie chart by dragging it to a new location.But it's highlighted in green in the image below:Ĭlick the down arrow and select the first Pie chart: In Excel 20, the Pie chart is harder to spot. I go over some of the most used elements in Excel 2016/365 and how to use them. Locate the Chart panel, and the Pie item:.Click the Insert menu at the top of Excel.Click inside cell E4 and change "Millions" to ITV, if you already have the data from a previous lesson.If you don't have this data, create the following simple spreadsheet. You've created a 2D chart with the BBC data. If you've been following along with the previous tutorials, then you'll have some viewing figures data. To make a start, you need to highlight some data. ![]() Later, you'll add some formatting to this: In case you're not sure what a Pie Chart is, here's the basic one you'll be creating. Pie charts are quite easy to create in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |