Set different colors for Excel2003 chart negative values

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.