The formulas used to create the table above are shown below.
Figure 1067 IF statements decide which color to use.
When you create the chart, create a stacked column chart. You will have to select each series and use Format, Shape Fill to choose the correct color.
Additional Details: An oversight in Excel 2007 made it impossible to control the color of the negative columns when you chose Invert If Negative. You could use a similar method to format negative columns.
Figure 1068 In Excel 2007, you had to use this method to show negative values in red.
In Excel 2010, you can use a regular column chart. Format the series. On the Fill category, choose Invert if Negative. you can choose Green for the first color and red for the second color.