3

Example chart

This is the chart that I had in mind. Similar to this chart, I have values for the amount of people that answered Agree/Neutral/Disagree to a specific question. Is there a way to center these answers around the middle of the "Neutral" category, just like in this chart? I can't seem to figure this out.

Improve this question
2
  • Please post a small sample of your data.
    – Gary's Student
    Jan 31, 2017 at 13:38
  • Without your data I can't give much better advice other than to make sure you have positive and negative data being used and use a Stacked Bar Chart. Chandoo did do a breakdown of this on his site previously - see here: chandoo.org/wp/2013/02/21/advances-vs-declines-chart - That might help more than an answer here :)
    – Miller86
    Jan 31, 2017 at 16:07

1 Answer 1

Reset to default
2

This is fairly easy to accomplish in Excel 2010 (I assume its similar in 2016). There are a couple different ways to do it, the easiest is to use a stacked bar chart, with:

  • negative values for the disagree
  • positive values for the agree
  • split the neutral in half (divide by two) with one half applied as negative and the other as positive-this will balance along the 0% mid-line.

sample

There is a detailed, step-by-step tutorial about this called Diverging Stacked Bar Charts.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .