Excel2010 chart Specifies that the color represents a negative value

Source: Internet
Author: User

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.

Operation Steps

1, select a cell in the data range, select the Insert tab in the Ribbon, and in the chart group, click bar → clustered bar.

Computer Tutorials

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.