Process to make a pie chart in excel how to#
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. You can also type in a clarifying label-e.g., 'Budget Allocation'-in the A1 cell. For example, if youre making a chart about your budget, the B1 cell should say something like '2017 Budget'. If you haven't got this style, select a similar one, such as style 4 in Excel 2013 and Excel 2016. To do so, click the B1 cell and then type in the charts name. Kasper Langmann, Co-founder of Spreadsheeto. In the Charts group, click Insert Pie or Doughnut Chart: If you forget which button is which, hover over each one, and Excel will tell you which type of chart it is. We've gone for the second one, Style two. First, highlight the data you want in the chart: Then click to the Insert tab on the Ribbon. You can also type in a clarifying label-e.g., 'Budget Allocation'-in the A1 cell.A1 cell. 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 : To do so, click the B1 cell and then type in the charts name. The chart is preceded by figures briefed in tables. Once you have your data highlighted, navigate to the Charts tab and find the Pie Chart dropdown menu. Notice how all the segments of the pie chart are the same colour in Excel 2007: The Excel waterfall chart template here will help you to analyze a certain outcome that is perceived throughout the year, from January to December.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. 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. Click on Insert on the toolbar and navigate to the Charts menu. 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.