title: Best way to plot multiple categorical data in Excel
body: <p>I have this data, which contains information from 0 to 10 on how good is a party, according to people interviewed.</p>
  
  <p>The columns represent the counts of each value that the person answered.</p>
  
  <blockquote>
    <p>(Label of the Data)</p>
  </blockquote>
  
  <p>Party_Name  1   2   3   4   5   6   7   8   9   10</p>
  
  <blockquote>
    <p>(Observations)</p>
  </blockquote>
  
  <p>PartyA  120 46  79  70  49  144 42  10  9   4   8</p>
  
  <p>PartyB  119 38  74  79  51  135 39  19  5   1   1</p>
  
  <p>The problem is that I have over 15 parties. What should be the easiest way to plot all of them?</p>
  
  <p>I've tried plotting them like this:</p>
  
  <p><a href="https://i.stack.imgur.com/MoMpW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MoMpW.png" alt="enter image description here"></a></p>
  
  <p>But I'd would like keep the bars the same colors, and maybe plot the other parties on the same plot, but with 2 by row, or something like that, and also label the bars with the numbers from "0-10".
  I hope I've made myself clear.</p>