How do I convert my stacked bar graph into a net stacked distribution

[gloomis]

Hi,

I have data from a liekert scale (Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree). I have created a stacked bar graph and would like to have a net stacked distribution. I would like all the neutral responses to line up vertically over the middle of the graph. This will make the bars different lengths, but it will visually be easier to see the responses.


http://www.organizationview.com/wp-content/uploads/2011/01/Stacked-distribution.jpg


http://www.organizationview.com/wp-content/uploads/2011/01/Net-stacked-distribution.jpg

 

[Andrew Poulsom]

Welcome to MrExcel.

Can't you use formulas to return the data that you want to plot?