Formatting a Chart Based On What Values Are Displayed
 

I do this by creating a new series for each "condition" you want to display.
Let's say you want to format points that are less than 100 as red, do
something like this

=if(A1<100,A1,NA())

The NA() values will not be displayed on the chart. Create a series for
each color you want to display.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



" wrote:

Hi,

I have a chart and I would like to format the line so that if it is
below a certain value, the line is red. Is there any way to do this?
I'm pretty good with charting in excel.