Reversing the data does not reverse it on the chart.
HOW TO MAKE A PIE CHART IN EXCEL 2007 HOW TO
In the next part, you'll see how to add the viewing figures to the pie chart segments. What you suggests only puts the items in the correct order for the legend. 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:.In the new window that pops up, click Add to add a new data series. Right click on the doughnut chart and click Select Data. Move your new pie chart by dragging it to a new location Step 3: Add a layer to create a double doughnut chart.
HOW TO MAKE A PIE CHART IN EXCEL 2007 PATCH
Create the pie chart and specify an output argument, p, to contain the text and patch objects created by the pie function. Create a pie chart with labels that contain custom text and the precalculated percent values for each slice. On the Insert tab, in the Charts group, choose the Pie button: 3. Make the font smaller or larger: Click the small A or the large A. But it's highlighted in green in the image below:Ĭlick the down arrow and select the first Pie chart: Select the data range (in this example A4:B9). In Excel 20, the Pie chart is harder to spot. Under Choose where you want the chart to be placed, do one of the following: To display the chart in a chart sheet, click New sheet. On the Design tab, in the Location group, click Move Chart.