How can I display a plus sign in a waterfall chart at positive levels and automatically color negative levels differently?

To display a “+” for individual values in waterfall charts, you can simply click on the Edit Data menu option.  

mceclip6.png

Then, in a separate window, your Excel table opens. Here you can click on the desired cell and click CTRL + 1 or by right-clicking on Format Cells and subsequently on Number  and  Custom to enter for instance the variant +#,##0;-#,##0 which contains a plus sign for positive values.

mceclip7.png

The result is, that the implemented format with a plus sign for positive values, will apply on the selected cell. To transfer this format to other cells, you can simply select the Format Painter and transfer the format by clicking on another cell.

mceclip8.png

If you want to color negative sections differently, you can do so automatically if you set this accordingly using the Series menu option.

mceclip9.png

The levels with negative values are then highlighted in color.

mceclip10.png

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.