title: ggplot 2 barplot with a diverging colour palette
body: <p>I currently have this barplot in R (created with <code>ggplot2</code>)
  <img src="https://i.stack.imgur.com/nuUa8.png" alt="enter image description here"></p>
  
  <p>I need to have it like this:</p>
  
  <p><img src="https://i.stack.imgur.com/COLoY.png" alt="enter image description here"></p>
  
  <p>I tried to use RColorBrewer package, but it didn't work since the maximum amount of colours in the coresponding palette is 11. Any ideas?</p>
  
  <pre><code>pal &lt;- brewer.pal(11,"RdYlGn")
  ggplot(data = bm_mod, aes(x = bm_mod$country, y = bm_mod$V)) + 
    geom_bar(stat = "identity", colour = pal, fill = pal) + coord_flip() + 
    labs(y="Under/over valuation in %", x="")
  </code></pre>
  
  <p>Here is the data: <a href="http://www.file-upload.net/download-8317296/bm_mod.csv.html" rel="nofollow noreferrer">link</a></p>
  
  <p>Update:
  I tried it again with this code:</p>
  
  <pre><code>ggplot(data = bm_mod, aes(x = country, y = V)) + 
    geom_bar(stat = "identity", fill = country, show_guide = FALSE) + 
    coord_flip() + scale_fill_manual(values = colorRampPalette(brewer.pal(11,"RdYlGn"))(nrow(bm_mod))) +
    labs(y="Under/over valuation in %", x="")
  </code></pre>
  
  <p>However the output looks pretty weird. Is it a problem with the brewer or another mistake?</p>
  
  <p><img src="https://i.stack.imgur.com/aug77.png" alt="enter image description here"></p>