ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Bar Chart colors less than zero (https://www.excelbanter.com/excel-discussion-misc-queries/216659-bar-chart-colors-less-than-zero.html)

ORLANDO VAZQUEZ

Bar Chart colors less than zero
 
Is there a way to change the color of the bars that fall below zero axis
line, ie y values greater than zero should be blue, less than zero should be
red.



Jon Peltier

Bar Chart colors less than zero
 
See this tutorial:

http://peltiertech.com/Excel/ChartsH...fNegative.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ORLANDO VAZQUEZ" wrote in message
...
Is there a way to change the color of the bars that fall below zero axis
line, ie y values greater than zero should be blue, less than zero should
be
red.





ORLANDO VAZQUEZ[_2_]

Bar Chart colors less than zero
 
This answers it perfectly. Thank you!

--
Orlando Vazquez


"Jon Peltier" wrote:

See this tutorial:

http://peltiertech.com/Excel/ChartsH...fNegative.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ORLANDO VAZQUEZ" wrote in message
...
Is there a way to change the color of the bars that fall below zero axis
line, ie y values greater than zero should be blue, less than zero should
be
red.







All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com