That's exactly why it's also named the "yes or no chart. That's how you can insert your chart with non-numeric data. You may need it, for example, for illustrative surveys. Another way to add a pie chart is to choose a blank slide in your presentation and select Insert > Chart. Then, select the Insert Chart icon (its the middle icon on the top row of the group of six icons shown in the body of the slide layout). Now it is obvious to prepare a stacked bar chart. Begin by adding a new slide using the Title and Content slide layout. From non-numeric sets of data I prepared a numeric data set. The countif formula will let me do that: = COUNTIF(B$3:B$7,"YES")/COUNTA(B$3:B$7)Īs you can see in rows 8 and 9, I calculated data. In the YES% and NO% rows, I will prepare numeric values for yes and no answers. To be able to create a stacked bar chart based on such data you need to calculate the data.
![create pie chart in excel with no numbers create pie chart in excel with no numbers](https://i.ytimg.com/vi/6uzPqJxd_Vk/maxresdefault.jpg)
Create pie chart in excel with no numbers how to#
Let's use such an example to examine how to create a stacked chart based on a non-numeric set of data. Thanks to the preferential column, you are able to create a chart showing how often your key customers make transactions. You are only interested in preferential customers.Ĭreate an additional column and, thanks to the if function, aggregate commercial and vip clients: =IF(D4="Private","NO","YES") You want to create a pivot chart with sales values. Private clients are not preferential to you. In this case, we have a sales report with 3 customer groups: Thanks to yes no data, I was able to prepare such a sales report pivot chart. Values is the count of yes/no data that I calculated just now. I've added an additional column for that purpose to get YES or NO values. From the whole sales report, you need to focus on sales above $10,000. This is the example when you need to prepare data based on a given condition.
![create pie chart in excel with no numbers create pie chart in excel with no numbers](https://cdn.extendoffice.com/images/stories/doc-excel/yes-no-pie-chart/doc-excel-yes-no-pie-chart-10.png)
Select the questionnaire table, and click Insert > PivotChart (or PivotTable) > PivotChart. Thus, you will get the chart on your sheet. Pie charts are used to display the contribution of each value (slice) to a total (pie). Create a pie chart for YES/NO answers with Pivot Chart 1. Now drag the respondents into values and drag the response into legend. Go to Insert and click the Pivot Chart button. Inserting a non-numeric chart Pivot yes no chart Yes no data preparationĮnter your non-numerical data into an Excel sheet and select it. You just need a simple yes-no chart in Excel. Sometimes you need to create a chart without numeric data. Yes No Chart with Non-numeric Data Details