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

G

gloomis

New Member
Joined
Apr 30, 2015
Messages
1
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

E
  • Question
Is it possible to choose how to combine clustered/stacked bars in a graph?
Replies
0
Views
358
excelos
E
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
D
  • Question
100% Stacked Bar Chart with % and Values
Replies
4
Views
1K
DSL1970
D
D
  • Question
how to create stacked bar for schedule/utilization
Replies
2
Views
779
sandy666
sandy666
T
  • Question
Stacked Bar Graph where each stack has it's own y-axis
Replies
3
Views
304
tusharm
tusharm

Forum statistics

Threads
1,216,073
Messages
6,128,637
Members
449,461
Latest member
kokoanutt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top