Excel2003 chart negative How to set different colors

Excel2003 chart negative How to set different colors

① to fill each negative bar in turn, the method can be, but not good enough, too time-consuming. We check the data series format interface to represent negative values in complementary colors.

② still found that negative bars are white and not eye-catching. By default, the color that is automatically filled with negative data points is white.

③ the data series in the chart double-click, open the Set Data Series Format dialog box, click the Fill Effect button, select the Gradient tab in the Fill Effect dialog box, and then select the Two-color option, in the Color 2 box, you can select the color you want to set for negative numbers.

After the ④ setup is complete, the effect is as follows, but it still does not achieve our goal.

⑤ again select the data series double-click, open the Set Data Series Format dialog box, check the complementary color to represent negative values, and then select a color in the Swatch for positive data, click OK to complete.

⑥ Blue represents positive values, and orange represents negative values, which completes the beginning of the goal.