conditional format of chart legend text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
My post was a suggestion for changing data label formats. I just noticed you asked
for legend entry formats. There's no such easy solution to this one. You can
manually format each legend entry (two single clicks: one selects the legend, the
second selects the entry, then pick the first item on the Format menu), or write a
macro to do it for you.

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