ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Auto-Color in Labels (https://www.excelbanter.com/charts-charting-excel/185047-auto-color-labels.html)

santiagojlinares

Auto-Color in Labels
 
Im trying to make a chart wich recognize a value from a data base and change
automatically the label's color depending if the value is positive or
negative. I mean; i'd like to be able to make that label (value) auto
formated as i can do in cells.

Thanks a lot

Jon Peltier

Auto-Color in Labels
 
What kind of label?

You can make a chart with conditional formatting if you're clever with
formulas:
http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"santiagojlinares" wrote in
message ...
Im trying to make a chart wich recognize a value from a data base and
change
automatically the label's color depending if the value is positive or
negative. I mean; i'd like to be able to make that label (value) auto
formated as i can do in cells.

Thanks a lot





All times are GMT +1. The time now is 12:34 AM.

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