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

0 votes

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

            -------------------------------------------
Nov 6 in Others by Kithuzzz
• 20,660 points
31 views

1 answer to this question.

0 votes

It should look something like this:

enter image description here

answered Nov 6 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
32 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
87 views
0 votes
1 answer

Use Excel pivot table as data source for another Pivot Table

Press the keys Alt+D+P in a new ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
47 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
140 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
238 views
0 votes
1 answer
0 votes
1 answer

Display a table (in the html/Excel spreadsheet meaning) in a iOS app in Swift

Here is the answer to your question: How ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
41 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP