title: How to create column chart in Excel with strings on both axis
body: <p>I want to do something so simple and realized Excel doesn't have straight way to do it, if it exists.</p>
  
  <pre>**Name Pet**
   Peter  dog
   Peter  cat
   Mary   cat
   Mary   dog
   John   cat
   Peter  dog
   Peter  dog
   Mary   dog</pre>
  
  <p>Just a simple column chart that given the name in X-axis I get two bars (dog,cat) for each name (Peter,Mary,John) with each bar the size of the count of the strings in Pet column.</p>
  
  <p>I can count the number of Peter's pets (Dog=3, Cat=1) for example and then graph that with the number, but I'm doing a massive data chart and need Excel to automatically create the column chart for me.</p>