[Excel] How to make a bar chart with negative values

If you have positive and negative values in a bar chart it’s useful to emphasize the difference automatically.

Excel bar chart displaying positive and negative values
Automatically switch colors for positive and negative values.

Design notes

  • In Excel, you can change the fill color (and other properties) of a data point, or split the series in two and change color for each series. However, in some cases you can set positive and negative fill colors, which is useful if you have a dynamic chart.