![how to make a pie chart in excel with data how to make a pie chart in excel with data](https://i.stack.imgur.com/YcOq8.png)
In Excel 2007, click the Office button and then click Excel options. Click the File tab and choose Options.You can hide the 0s by unchecking the worksheet display option called Show a zero in cells that have zero value. Neither line chart handles the missing 0s well, as you can see in Figure B (if you removed the 0 values in the sheet, re-enter them before you continue). The pie chart doesn’t chart the missing 0s, but the legend still displays the category label. The stacked bar responds well to this solution. Unfortunately, this simplest approach doesn’t always work as expected. You might try removing the 0 value altogether if it’s a literal 0 and not the result of a formula. Some will work with limited results, and some won’t work at all - but ahead and try them. Now that you’re familiar with the example data, let’s review a few methods for suppressing the 0 values in our example charts. The other two charts have three data series: Vendor 1, Vendor 2, and Vendor 3. The pie and single line charts reflect the data in column B for Vendor 1. Simply close the file and reopen without saving.
![how to make a pie chart in excel with data how to make a pie chart in excel with data](https://static2.makeuseofimages.com/wordpress/wp-content/uploads/2017/07/pie-chart-excel.jpg)
If you work through the instructions with the example workbook, be sure to undo each solution before you start the next. Your results might vary, depending on your version of Excel and your chart defaults. LEARN MORE: Office 365 Consumer pricing and features About the example dataįigure A shows the data and initial charts that we’ll use throughout this article. We’ll review a few that offer quick but limited results with minimum effort. When you don’t want to display these values, you have a few choices, and some work better than others. Your data and the chart’s purpose will guide you in this decision. The steps are similar to what Susan Harkins describes in the following tutorial.Ĭharting 0s isn’t wrong, but you won’t always want to display them in your Excel charts. For this demo, he uses Microsoft Office 365.
#How to make a pie chart in excel with data how to#
In the next part, you'll see how to add the viewing figures to the pie chart segments.Editor’s note: In the video, Brandon Vigliarolo walks you through a couple of ways for suppressing 0 values in Excel charts. 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. We've gone for the second one, Style two. 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. 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.