When you make a bar or column chart in Excel, all of the data bars (or columns) are the same color by default. There are times when the data is negative and it will be more visible if you can use other colors in the chart to represent negative values. In Excel 2010, you set the method as follows:
As shown in the figure is the monthly average temperature data of a city, it is necessary to make a bar chart.
1, select a cell in the data range, select the Insert tab in the Ribbon, and in the chart group, click bar → clustered bar.
2, double-click the data series in the chart, pop-up the Format Data Series dialog box, select Fill. Select solid fill in the right area and tick negative values in complementary colors. A color selection button is added to the lower fill color area, click the Color selection button on the right to select a color, such as red, and then close the dialog box.
3, the negative values in the chart will be filled with red.
4, the final according to the need to delete the legend, adjust the vertical axis of the label and axis distance can be.