Set different colors for Excel2003 chart negative values

A bar chart is created in Excel2003 to indicate positive values, which are displayed in different colors. How do I do that? directly set up the chart, the color is the same, I will take time to explain some of the following.

① 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.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join