Yes, you can make a yes/no chart in Excel. Put the responses in a column, count each answer in a small summary table, and insert a column, bar, or pie chart from that summary; Excel will display the Yes and No totals as chart categories.
What a Yes/No Chart Shows
A yes/no chart is a way to visualize how many responses fall into two categories. For example, a team might record whether each person completed training, a survey might ask whether customers would recommend a product, or a checklist might track whether tasks are finished. Excel does not have a special chart type named Yes/No. Instead, you prepare the answers as categories and use a standard chart type to compare them.
The chart is useful when the balance between the two answers is easier to grasp visually than by scanning a list. It can show counts, such as 6 Yes and 4 No, or proportions, such as 60% Yes and 40% No. A chart summarizes the data; it does not decide what counts as a Yes or No. If the source column contains inconsistent entries such as Yes, YES, Y, and yes with a trailing space, clean or standardize them so the chart represents the responses you intend.
Choose a Chart Type That Fits the Question
A clustered column chart is a dependable default for comparing Yes and No counts. Its vertical bars make the difference between the categories easy to compare, and the chart still works well if the totals are not equal. A horizontal bar chart is useful when category labels are longer, although the simple labels Yes and No usually fit either orientation.
A pie chart can work when there are exactly two categories and the goal is to show each category as a share of one whole. A doughnut chart serves a similar purpose. These charts are less suitable if readers need to compare small differences precisely; column or bar lengths are generally easier to compare than pie slices. A 100% stacked chart is another option when comparing the yes/no proportions across multiple groups, such as responses by department. For just one group, it often adds no useful information beyond a simple bar chart or two-number summary.
- Compare counts: Use a clustered column or bar chart.
- Show the share of a single total: Consider a pie or doughnut chart, and label the slices clearly.
- Compare proportions across groups: Use a 100% stacked column or bar chart, with one series for each answer.
Prepare the Response Data
Keep the raw answers in one column, with a clear heading such as Answer. For the example below, assume the heading is in A1 and the ten responses are in A2:A11. The entries are Yes or No, with six Yes answers and four No answers. Each row should represent one response, and the entries should use consistent wording. Avoid merging cells or inserting blank rows inside the list, since those choices make it harder to count and maintain the data.
If responses come from several sources, decide how to handle missing answers before making the chart. A blank is not automatically a No: it may mean the person did not respond. Likewise, values such as Not sure or Not applicable are separate categories unless your reporting rules explicitly combine them. Keeping those distinctions prevents a visually neat chart from communicating the wrong result.
For a small hand-entered list, you can type Yes and No directly. If the data is collected repeatedly, consider using a dropdown list to reduce spelling differences. In Microsoft 365 for Windows, select the response cells and choose Data > Data Validation, then set Allow to List and provide Yes,No as the list source. This limits new entries to the supplied choices, but it does not automatically fix inconsistent entries already present.
Count Yes and No Responses
Create a summary table away from the raw data. For example, enter Response in D1, Count in E1, Yes in D2, and No in D3. With the ten responses in A2:A11, enter this formula in E2 to count Yes answers:
With responses in A2:A11, enter in E2: =COUNTIF(A2:A11,"Yes"). The example returns 6.
With responses in A2:A11, enter in E3: =COUNTIF(A2:A11,"No"). The example returns 4.
COUNTIF checks the specified range against the criterion. Its text matching is not case-sensitive, so YES and yes are counted as Yes. However, an entry with extra spaces or a different word may not match the criterion in the way you expect. If the list has been cleaned and there are no other valid categories, the two counts should add up to the number of responses. If they do not, check for blanks, typos, or additional answers rather than assuming one category is missing from the chart.
Insert the Chart in Excel
Once the summary table contains the category names and their counts, build the chart from that table rather than selecting the entire response list. This gives Excel a simple, clear set of labels and values to plot.
- Select D1:E3, including both column headings and the Yes and No rows.
- On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel creates a chart with one column for each answer.
- To use horizontal bars instead, choose Insert > Insert Column or Bar Chart and select the 2-D Bar clustered option.
- To make a pie chart, select the same summary range and choose Insert > Insert Pie or Doughnut Chart, then choose a 2-D pie or doughnut style.
These paths describe Excel for Microsoft 365 on Windows. In Excel for Mac, use the Insert tab and the chart choices there; names and the arrangement of chart menus can vary slightly by release. Excel for the web also offers chart insertion from the Insert tab, though some formatting options may be less extensive than in the desktop application.
Make the Chart Easy to Read
Give the chart a descriptive title, such as Training Completed: Yes and No. A title that identifies the question or population is more helpful than a generic label like Results. If the chart appears in a report without its source table, a short note can explain the sample size, time period, or what one response represents.
For a column or bar chart, consider adding data labels so readers can see the exact counts without estimating bar lengths. In Microsoft 365 for Windows, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a suitable position. For a pie chart, labels can show category names, values, or percentages; avoid showing so many label details that the chart becomes crowded. You can also use contrasting colors for Yes and No, but do not rely on color alone to explain the categories. Keep the labels visible and use a sensible scale. In particular, a column chart whose value axis begins far above zero can exaggerate a small difference.
Check that the displayed values match the summary table. If you choose a pie chart, its slices represent the proportion of the values in the selected range. With counts of 6 and 4, the shares are 60% and 40%. These percentages describe the ten recorded responses, not necessarily a wider population, unless the way the responses were gathered supports that conclusion.
Keep the Chart Updated as Data Changes
A chart based on a fixed range such as A2:A11 will not necessarily include answers typed below row 11. The summary formulas and chart source both need to cover the added data. For a growing list, convert the raw data into an Excel table: select the data, including its heading, and choose Insert > Table or Home > Format as Table. Confirm that the table has headers.
Excel tables expand when you add rows directly below them, which makes them a practical way to manage changing lists. A chart linked to a table can include added table rows, but check the chart after adding data, especially if it was created from a separate summary range. The summary counts must also refer to the growing source. You can edit a chart’s source through Chart Design > Select Data if the plotted range needs correction. For a one-time chart, a fixed range may be simpler; for a recurring report, a table-based source reduces maintenance.
Common Problems and Misconceptions
One common mistake is charting the raw Yes and No text column directly. A standard chart needs categories and numeric values, so Excel may not produce the count comparison you had in mind. The summary table solves this by turning the answers into two category labels and two numbers.
- The chart shows an unexpected count: Check the source range for blanks, extra spaces, alternate spellings, or entries such as N/A. Confirm that the formulas and chart include all intended rows.
- The chart has the wrong labels: Verify that the selected range includes the Response and Count headings and both summary rows. Use Chart Design > Select Data to review the plotted range and category labels.
- The pie chart shows only one slice: Confirm that both categories have numeric counts and that both rows are included. A zero count has no visible slice, even though the category may appear in the source table.
- Yes and No appear as separate series instead of categories: The chart may have interpreted the selected rows and columns in the wrong direction. Use Chart Design > Switch Row/Column or adjust the source layout so the two answer names form the category labels.
Another misconception is that a chart can validate the underlying answers. It cannot tell whether a respondent selected the right option or whether a missing response should count as No. It only visualizes the values supplied to it. Define the categories and the treatment of missing or uncertain answers before interpreting the chart.
When a Chart Is Not the Best Choice
If the response count is small or the chart will be viewed in a narrow space, a labeled summary table may communicate the result more clearly than a chart. For example, a report could simply show Yes: 6 and No: 4, plus the total of 10. A chart is most useful when it helps readers compare categories quickly, when it will be compared with other groups, or when the visual presentation matters.
If you need a visual indicator for each individual task rather than an overall count, a chart may be the wrong tool. A status column with Yes/No dropdowns, conditional formatting, or a checkbox-based task list can show item-level completion. Those are different spreadsheet designs: a chart aggregates values, while a list or status display preserves the detail of each record.
Frequently Asked Questions
Can Excel make a chart from Yes and No text?
Yes, but for a clear count chart, first summarize the text into category names and numeric totals. Selecting the raw text list alone usually does not provide the count-based comparison most readers want.
Which chart is best for Yes and No responses?
A clustered column or bar chart is a strong default for comparing counts. Use a pie chart when the aim is to show the two categories as shares of one total, and make sure the labels make the proportions clear.
How do I show percentages instead of counts?
Use counts that add up to the total, then display the categories as percentages in a pie chart or calculate percentages in a separate summary table. State the denominator or sample size so readers know what the percentages describe.
Why is my Yes/No chart counting responses incorrectly?
Look for misspellings, trailing spaces, blanks, extra categories, or a formula range that stops before the last response. Also check whether the chart uses the correct summary cells rather than the raw answer column.
Will the chart update when I add more answers?
It depends on the source range and how the summary is set up. A fixed range may exclude new rows. An Excel table can expand with added records, but verify that the summary calculations and chart source include those rows as well.
Related
- Use Power Query to Merge Excel Files: A Practical Guide
- Update Number Format in Excel: How to Change Formats
- US Number Format in Excel: Dates and Numbers
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Box Plot: Add a Series and Expand the Chart DataTo add a series to an Excel box plot in Microsoft 365 for Windows, select the chart, choose…
- Superscript in Excel Chart Legends: Methods That WorkTo show superscript in an Excel chart legend, put the superscript character directly in the series name—usually the…
- Excel Horizontal Bullet Chart: Build One Step by StepTo make a horizontal bullet chart in Excel for Microsoft 365 on Windows, create a stacked bar chart…
- Org Chart in Excel: Templates, Setup, and Best PracticesYes—Excel includes a built-in way to make an org chart: choose Insert > SmartArt > Hierarchy > Organization…
- Consolidate Multiple Pivot Tables in ExcelTo consolidate information shown in multiple PivotTables, combine their underlying data first, then build one PivotTable from the…
- Excel Pie Chart: Remove Zero-Value LabelsTo remove a zero-value label from an Excel pie chart, click the chart, click the label once to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.