Trying to create a stacked column chart with data above and below the x-axis

Hello:

I am trying to create a stacked column chart with data above and below the x-axis. The issue is that the data is not separated by positive and negative values; The data I am using is from a survey and I would like to have responses to certain questions above the axis, and responses to the other questions below the axis.

So the data looks something like this (this is just an example):

Pretty Good Good Bad Pretty Bad
Apples 2% 10% 25% 8%
Oranges 5% 9% 5% 5%
Bananas 6% 5% 7% 5%

I would like to have the percentages for Pretty Good and Good above the x-axis, and Bad and Pretty Bad below the x-axis. There would be three stacked columns on the x-axis: 1) Apples, 2) Oranges and 3) Bananas.

Any suggestions would be great! Thanks!

here are the steps to set this up:

1. enter the data on the sheet like you specified
2. make 'bad' and 'pretty bad' values negative (e.g. apple, bad = -25%)
3. select block of cells, press F11 to create chart
4. change chart type to 'Stacked Column'
5. press 'Switch Row/Column' button

is that what you're after?

Yes, this worked, thank you very much!