title: How to combine two pivot tables into one chart in excel
body: <p>I have two pivot tables, each with two columns. One column is a range from 0 to 6.5, grouped by .5 and the other column is the percentage of the whole column that the data falls into teach grouping. I need to compare these two pivot tables with an area chart that shows both areas overlapping, but I don't know how to do this.</p>
  
  <p>I can make an area chart for each one individually, but I don't know how to structure the data to make the aforementioned combined chart. Here is the data:</p>
  
  <p><a href="https://i.stack.imgur.com/md3Bl.png" rel="nofollow noreferrer">The Data and Charts</a></p>