how to make a pie chart in excel with names

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. The code below shows how to create a basic Pie Chart in SAS.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. With the data option and template option you define the data set and template that must be used to create the chart. In our case, the Iris Species are our categories.įinally, with the SGRENDER procedure, you create the chart. Next, with the category option, you specify the categories of the Pie Chart. Within the layout section of your template, you use the piechart statement to define the chart type. In our first example, we only want to show a default Pie Chart. So, here you can define the actual chart type, the title(s), colors, etc. Then, between the begingraph and endgraph statements, you specify how your chart will look like. When you generate the chart with the SGRENDER procedure you use this name to refer to the template. Following this statement you specify the name of the template in this case my_pie_chart. The define statgraph statement is the first statement within the TEMPLATE procedure. To actually show the chart on a screen we use the PROC SGRENDER procedure. With this procedure, we define the chart. In this article, we will use the PROC TEMPLATE procedure to create a Pie Chart in SAS. Frequency Table of the Species Create a Basic Pie Chart

How to make a pie chart in excel with names