title: ggplot2 for a newbie multiple columns grouped in a bar chart?
body: <p>I am trying to make a plot with ggplot2 and i cannot really get my head around how to do it.</p>
  <p>My df is laid out like the below:</p>
  <p><a href="https://i.stack.imgur.com/poHWI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/poHWI.png" alt="enter image description here" /></a></p>
  <p>I would want the graph to show the X axis with the Area name with a bar chart of each of the column headings, I am able to do  it for one of them but i am unsure how to combine them together.</p>
  <p>Or I have seen facet_wrap been used which could create a graph for each area name and the 4 bars with their corresponding values in each facet.</p>
  <p>This is what I have come up with so far...</p>
  <pre><code>wlcalcs %&gt;% ggplot(aes(y= `80+ % d1`, x= `Area`)) + geom_bar(stat='identity')
  </code></pre>
  <p>So I have combined the fields I need into two new fields on my dataframe called &quot;New&quot; and &quot;Values&quot; this is my updated ggplot2 code below but doesnt seem to work for whatever reason. My New field is effectively 80+ %d1 X with x corresponding to its value line by line.</p>
  <p>I want a facet for each Area name and I want the values of 'New' to be my X axis and values of 'Y' (the percentages) to be the fill for each of them bars.</p>
  <p>I am probably doing somethign wrong but i hope im on teh right track</p>
  <pre><code>test1 &lt;- ggplot(data = test) + 
    geom_bar(mapping = aes(x = `New`, y = `Values`)) + 
    facet_wrap(~ group_by(`Ward Name`, nrow = 2))
  </code></pre>
  <p>Any help is appreciated, this is the first time i have used R pretty much and first time trying plots out. I assume some combined field needs to be done as I have had a search around but cannot really understand it too well</p>