So that Incomplete will pick automatically. We can observe the changes in the chart and text if we input the formula in “Incomplete” like 100%-completed-Work InProgress. Now change the percentages and see how the chart changes. Similarly, input the text for incomplete and work inprogess. From the right-side menu, select “Text options” and change the color to “Orange”. Select the text and right-click from the pop-up, select the formatting data series, and a menu will appear on the right side. Now it is showing in Orange color hence we will set the text color also in “Orange”. Now apply a format to the text as per your doughnut color for that particular field. Select the Fill and select No Fill, then the blue color will disappear. Right-click on the text and select the format. For that input = (equal sign) in the text box and select the cell which shows the value of completed status that is B2. Now give the formula to represent the status of the project. Now click on the inserted rectangle shape and select the Text box, shown in the picture below. Now to input, the percentage text selects the Doughnut Then click on Shapes under Illustrations option from Insert menu and select Rectangle box. The “Format Data Series” menu reduces the Doughnut Hole Size. When clicking on the Format Data series, a format menu appears on the right side. Select the chart and right-click a pop-up menu that will appear from that, select the Format Data Series.
Once you do that, the chart will look like below. Untick the Chart Title and Legend to remove the text in the chart. Now click on the + symbol that appears top right of the chart, which will open the popup. Select the data table and click on the Insert menu.
We will create a doughnut chart to represent the project status percentage-wise.Ĭonsider the example of the above status of the project and will create a doughnut chart for that.
#How to create pie chart in excel 1007 how to
In the next part, you'll see how to add the viewing figures to the pie chart segments.You can download this Doughnut Chart Excel Template here – Doughnut Chart Excel Template Doughnut Chart in Excel – Example #1įollowing is an example of a single doughnut in excel: Single Doughnut Charts in ExcelĬonsider a project which has three stages like completed, work InProgress, Incomplete. 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.
0 kommentar(er)
