After choosing the colors, click Close button to exit the dialog, and now, you can see the positive and negative data bars have been filled with different colors separately in your chart.ġ. Then you need to fill color for the data series, please check Solid fill option in the right section, and choose the colors for your positive and negative data bar as you like under the Fill Color section, see screenshot:Ĥ. Then in the Format Data Series dialog box, click Fill in the left pane, and check Invert if negative option, see screenshot:ģ. Right click the data series bar, and choose Format Data Series from the context menu, see screenshot:Ģ. In fact, there is an option called Invert if Negative feature which can help us to give a different color for the negative bar in Excel, please do as follows:ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 Comments
Leave a Reply. |