title: Pivot Chart Table in Excel To Calculate the Count and Display the Chart
body: <p>Here is my Sample Data</p>
  
  <pre><code>            ****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
  </code></pre>
  
  <p>Where i need to create a pivot chart for table like this where i need to count the Number of Result for a particular date and for particular Name</p>
  
  <p><strong>Example:</strong></p>
  
  <p>the chart should produce result something like this</p>
  
  <pre><code>            Date| Name | Pass | Fail | Pending | No Response
  
              01-09-14| John | 1 | 1 | 0 | 0
  
              01-09-14| Raja | 0 | 0 | 2 | 0
  
              -------------------------------------------
  </code></pre>
  
  <p>Where i tried of adding an another sheet and table for counting seperately for pass, fail, pending... values and from there i created a pivot chart, but the actual table extends further</p>
  
  <p>For example new user can add, new date will be added in future, as like that chart also have to be responsive of adding new user and new dates , so i failed in that point,</p>
  
  <p>so is there any way to make the pivot chart to be responsive though new user or new date is added, the chart has to built automatically and to show the count result of particular date and particular name</p>