conditional format of chart legend text

B

bcnu

I've seen a lot about conditional format on chart points, but I'm looking to
turn legend text one of 3 colors depending on a cell value. I am creating a
stoplight type of chart where if a value (column n is <x the category title
in column l is red; if n is between y and z then the title in column l is
yellow and if column n > z then the title in column l is red). I wanted to
have the legend text change color based on the value being plotted, if
possible. Thanx for any help/advice.
 
A

Andy Pope

Hi,

I suspect you will require some VBA code to solve this problem.

You could either change the legend font colour when the cell data changes.
Or create additional duplicate data series, formatting the legend entry
with the required colours, and then hide columns of data not required.

If you can live with a VBA solution and required further
information/help then post back.

Cheers
Andy
 
B

bcnu

Andy,

Thanx. I was afraid of the VBA answer. I appreicate your feedback, but my
client doesn't want to do it with code. We'll leave it as is. Thanx again.
I've been on travel so sorry for the late response.
 
Top