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

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