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,000 points • 863 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,600 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,000 points • 843 views
0 votes
1 answer

Find nearest gas station using google maps v2 in android and want to display the route to it

The code snippet is the following (you ...READ MORE

answered Jun 9, 2022 in Others by nisha
 • 2,210 points • 679 views
0 votes
1 answer

How to run the table function in R across multiple variables and compile the results into a new dataset using a function?

0 Your b effort would be a good ...READ MORE

answered Jun 24, 2022 in Others by Sohail
 • 3,040 points • 946 views
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: ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
 • 63,600 points • 651 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,600 points • 1,298 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,600 points • 14,509 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,690 points • 4,141 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,690 points • 2,014 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

answered Feb 5, 2023 in Others by narikkadan
 • 63,600 points • 1,207 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,600 points • 1,158 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.