Plot positive AND negative change on the same axis

1. How do I add positive and negative axis in Excel?
2. Which type of bar chart will show positive and negative values?

How do I add positive and negative axis in Excel?

First select your chart, then click on the Vertical Axis and press CTRL+1 to bring up the Format Axis dialog box. Then choose the Custom Category from the Number section. Then in the Format Code box, add a negative sign '-' and press the Add button.

Which type of bar chart will show positive and negative values?

Horizontal Bar Chart With Negative Values

Bar charts that display negative and positive values at the same time should be easy for the understanding and recognition of both types of values. Great way to make it clear is to divide such bar chart into a two parts by Y-Axis.