title: Excel Graph - Category and Subcategory grouping
body: <p>I seldom if ever use excel and have no deep understanding of graphs and graphing-related functions. Having said that...</p>
  
  <p>I have dozens of rows of data, composed by 4 columns</p>
  
  <ul>
  <li>column 1 = amount/price (in numbers)</li>
  <li>column 2 = description (the what
  in text)</li>
  <li>column 3 = category (in text)</li>
  <li>column 4 = subcategory (in
  text)</li>
  </ul>
  
  <p>I want to make a bar graph of my rows of data so that, the end result looks like this:</p>
  
  <p>X axis - categories
  Y axis - amount/price</p>
  
  <p>The trick here is for categories NOT to repeat themselves. For example, if our data is something like...</p>
  
  <ul>
  <li>100 | boat purchase | boats | 3 engine boat</li>
  <li>200 | boat purchase |
  boats | 2 engine boat</li>
  <li>500 | plane purchase | planes | 4 engine plane</li>
  <li>900 | car purchase | cars | 1 engine car</li>
  </ul>
  
  <p>Then there should only be ONE instance of boats, planes and cars in my graph, under which all associated data would be summed up.</p>
  
  <p>Last but not least, I have seen graphs where, these unique-not-repeated categories, instead of just being one single 'bar' so to speak, are composed of smaller bars. In this case, I want these smaller bars to be the sub categories, so that the end result would look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/RSu7S.png" alt="basic and complex graph samples"></p>
  
  <p>In that sample image, I first present a 'basic, classic' graph where blue, yellow and red each represent a unique, different category. Right below it is what I want, a 'breakdown' of each category by subcategory where blue/yellow/red each represent an imaginary 3 different subcategories per category.</p>
  
  <p>This means subcategories will repeat themselves for each category, but categories themselves will not.</p>
  
  <p>For clarification, I currently only have 3 main categories and 6 or so sub-categories, but this could change in the future, hence the desire to have this in an automatic/dynamic fashion</p>
  
  <p>Kind regards
  G.Campos</p>
  
  <p>EDIT: new image:</p>
  
  <p><img src="https://i.stack.imgur.com/yPLsJ.png" alt="better explanation of desired graph result"></p>