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, 2022 in Others by Kithuzzz
• 38,010 points
573 views

1 answer to this question.

0 votes

It should look something like this:

enter image description here

answered Nov 6, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

How to create arrow buttons in Excel to scroll the table left and right?

Ctrl-shift-home goes to the upper-left of all ...READ MORE

answered Mar 26, 2023 in Others by Kithuzzz
• 38,010 points
489 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, 2022 in Others by narikkadan
• 63,700 points
458 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

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

answered Oct 7, 2022 in Others by narikkadan
• 63,700 points
1,053 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, 2022 in Others by narikkadan
• 63,700 points
11,528 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, 2022 in Others by Edureka
• 13,670 points
1,745 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, 2022 in Others by Edureka
• 13,670 points
1,568 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,700 points
893 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