Formatting a Chart Based On What Values Are Displayed

  • Thread starter nouveauricheinvestments
  • Start date
N

nouveauricheinvestments

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.
 
B

Barb Reinhardt

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.
 
Top