How to create stacked bar chart / quartile chart with negative starting value

I cannot find good documentation for the behavior of stacked bar/column charts with negative values. As near as I can tell, negative values stack beneath each other starting at 0 and positive values stack on top of each other starting at 0. I know of no way to change this behavior in Excel (not sure about other charting applications), so you will need to program the spreadsheet to handle quartiles that cross 0. After studying the behavior of stacked column charts, here's what I ended up doing for your data:

1) Since 0 is the "hinge" point for the different stacking algorithms, I add a 0 value to the source data. Enter 0 in B9:G9.
2) I want to see the data sorted, so I sort the data. My older version doesn't support the SORT() function, so I use the LARGE() function to sort from large to small.
2a) Enter 1,2,3,...6 in A19:A24.
2b) Enter =LARGE(B$4:B$9,$A19) in B19, note the mix of relative and absolute references, and copy/paste/fill into B19:G24.
3) I want to know where the 0 is. I choose the RANK() function for this. Enter =RANK(0,B$4:B$9,0) in B26 and copy/paste/fill into B26:G26.
4) Now, starting where 0 is, I want to work "down" from 0 and calculate the differences/lengths of bars for all negative entries. In order to make some chart formatting easier later, I'm going to do some extraneous calculations that result in errors.
4a) I want to start where 0 is, so I enter =B$26 in B28. Counting down from 0 is adding rows, so I enter =B28+1 in B29. There are 6 total, so I copy B29 and paste/fill into B29:B34. Select B28:B34 and copy/paste/fill across to column G.
4b) I can use INDEX() to pull the appropriate values from rows 19:24, and subtract. (Leaving room for some above 0 stuff), I enter =INDEX(B$19:B$24,B29)-INDEX(B$19:B$24,B28) into B42. Copy/paste/fill into B42:G46. Remember that there will be several errors in this range, but the errors should not impact the final chart.
5) Starting where 0 is and work up through the positive values.
5a) Select B28:G28 and copy into B35:G35. In B36, enter =B35-1 and copy/paste/fill into B35:G40.
5b) Again, use INDEX() to extract the appropriate values from 19:24 and subtract. This is the same formula as 4b, so select B42:G46 and copy into B48:B52.

6) Now I have all of the bar lengths calculated in rows 42:52, with errors where there is no bar length to be calculated (the chart will treat the errors as if they are 0). I can now create my stacked column chart. Select B1:G1 <ctrl> B42:G52 -> insert stacked column chart.
7) Because 0 is not a real data point in the chart, I really want the first negative series and the first positive series to look the same so that the reader will see that this is the same quartile. This is part of why I did separate count down from 0 and up from 0 sections. I wanted the first negative series and the first positive series to always be in the same row (in this case, rows 42 and 48). Select the series associated with row 48 and format this series so it looks like row 42 (or 42 so it looks like 48, or some other combination of both so that these two series look the same).
8) Add rows 2 and 3 as line chart series to complete the combination chart. Format other chart elements as desired and evaluate the result.

It's a lot of hoops to jump through to get the same kind of behavior that stacked line and stacked area charts do automatically. You just need to understand how stacked column/bar charts work with negative values, then adapt your spreadsheet to make the right calculations that go with the chart behavior.