Waterfall Chart with automatic coloring and text coloring

[amartino44]

Hello. I FINALLY figured out how to create a correct waterfall chart. Now what I want to do is to have the values be on top of each column in the chart AND I would like to conditionally format these numbers so that negative values will be in green text and and positive values in red text. Is this possible? I tried to put the values on the top but it shows 0's and I don't want it to show the 0's. Help!!! Spreadsheet attached.

[Mallycat]

go to "add chart elements" and select "add data label". Chances are that the values will not be what you want. you can then select each label individually, click in the formula bar, press = and then point to the correct value in your spreadsheet. So if you don't have the right value in the sheet already, just create a new column of the correct values. I don't know a way to format the numbers the way you describe other than doing it manually - ie they wont update if the value changes.