Chart Labels - Conditional Formating
 

Hello, Is there a way to pick up (in my x-axis labels) the conditional
formatting from my data table? I have a simple dashboard of project statuses
and I highlight each project status as Red, Green, Yellow to signify level of
risk. I want to translate these colors into a chart with the chart changing
as the status in the table changes. Any suggestions appreciated!

Scott

Chart Labels - Conditional Formating
 

Hi,

No automatic way. There is also an added problem in that formatting
individual labels in the axis is very limited especially if you want
multiple conditions impossible.

So you need to build you own axis labels.
http://www.andypope.info/charts/hiliteaxislabels.htm

Cheers
Andy

Scott wrote:
Hello, Is there a way to pick up (in my x-axis labels) the conditional
formatting from my data table? I have a simple dashboard of project statuses
and I highlight each project status as Red, Green, Yellow to signify level of
risk. I want to translate these colors into a chart with the chart changing
as the status in the table changes. Any suggestions appreciated!

Scott

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info