help making a chart

Occasional Visitor

i need to make a specimen submission error log, I have 73 specimens collected, and out of those 73 there were 28 specimens with error, the reasons why are Incorrect information and Mismatch bottle. 

how do I show this in a chart when the reasons don't have a value. 

2 Replies


You might create a pivot table based on the data. See for example Create a Pivot Table in Excel if you're not familiar with them.

Add the reason field (column) to both the Rows area and the Values area of the pivot table.

Excel will show the number of specimens for each reason.

You can then create a column chart or bar chart based on the pivot table.


It could look like this: