I'm trying to create diverging stacked bar charts in Excel 2007.

By making some of the values negative, I can get those values to display to the left of the vertical axis. However, columns B through F are in the wrong order on the chart. I highlighted one of the columns of data to make it easy to track them in the two examples.

By reversing the order of columns B through F, I can make the chart display correctly (Example 2 in the attached file), but the legend isn't in the correct order.

Diverging Stacked Bar Worksheet.xlsx

Am looking for help on this, or if there's a better way to do the diverging stacked bar chart in Excel.

Thank you!
Lis