Pivot Chart Table in Excel To Calculate the Count and Display the Chart

Question

Here is my Sample Data

            ****Date |  Name |  Result****

            01-09-14 |  John |  Fail

            01-09-14 |  John |  PASS

            01-09-14 |  Raja |  Pending

            01-09-14 |  Raja |  Pending

            01-09-14 |  Natraj |    No Response

            01-09-14 |  Natraj |    PASS

            02-09-14 |  John |  PASS

            02-09-14 |  John |  No Response

            02-09-14 |  Raja |  Fail

            02-09-14 |  Raja |  Pending

            02-09-14 |  Natraj |    No Response

            02-09-14 |  Natraj |    PASS

            02-09-14 |  Natraj |    Fail

            02-09-14 |  Natraj |    Fail

I need to make a pivot chart for a table like this so that I can count the number of results for a specific date and name.

Example:

The chart should produce a result something like this

            Date| Name | Pass | Fail | Pending | No Response

            01-09-14| John | 1 | 1 | 0 | 0

            01-09-14| Raja | 0 | 0 | 2 | 0

            -------------------------------------------

Answer 1

It should look something like this: