title: Make a piechart that can read dropdown lists? - Google Sheets
body: <p>I am struggling to make a piechart of my expenses that can interpret a dropdown list.</p>
  <p>Whenever I try to create the chart somehow the graph cant realize that Categories with the same name should be grouped together. It's driving me insane to the point I registered here!</p>
  <p>Does anybody have any input on how to get around this?</p>
  <p>Thank you!</p>
  <p><a href="https://i.stack.imgur.com/aINza.jpg" rel="nofollow noreferrer">Picture of the problem</a></p>