Any way to make the following chart (pictured) in excel?

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.

Mark Malakh

Posted 2017-01-31T11:24:31.073

Reputation: 31

Please post a small sample of your data. – Gary's Student – 2017-01-31T13:38:09.233

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: http://chandoo.org/wp/2013/02/21/advances-vs-declines-chart/ - That might help more than an answer here :)

– Miller86 – 2017-01-31T16:07:21.977

Answers

1

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.

dav

Posted 2017-01-31T11:24:31.073

Reputation: 8 378

Asked: 2017-01-31T11:24:31.073

Viewed: 2 460 times

Active: 2019-10-09T17:01:10.297