Is it possible to change the line width (or color) based on a if-then statment?
For example: if the value of one line if hitting new lows for the day but
the value of another line is not hitting new lows for the day is it possible
to change the width or color of the first line because this condiition is
false?
Thanks!

Hi,

This example demonstrates how to change the line above and below a datum.
http://www.andypope.info/charts/conditionalline.htm

It gets more complex if you do not want the datum line, which is masking the
fact that the other 2 lines are still continuous.
Without the datum you will need to include empty points in the addition
series to cause the lines to have gaps.

You might find this approach more manageable, which is to highlight the
specific points along the line rather than a segment of the line.
http://peltiertech.com/Excel/Charts/FormatMinMax.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"andy" wrote in message
...
Is it possible to change the line width (or color) based on a if-then
statment?
For example: if the value of one line if hitting new lows for the day but
the value of another line is not hitting new lows for the day is it
possible
to change the width or color of the first line because this condiition is
false?
Thanks!

This site is more of what I am looking for, thank you.
http://peltiertech.com/Excel/Charts/FormatMinMax.html

I have a data series that has over 1500 data points. There are mulitple
highs/lows in the data series. For the max/min values it is conecting all
the data points. Is there a way to only plot the numerical values? Here is
my formula:
=IF($B2=MAX($B2:$B$1563),$B2,NA())
Thanks!


"Andy Pope" wrote:

Hi,

This example demonstrates how to change the line above and below a datum.
http://www.andypope.info/charts/conditionalline.htm

It gets more complex if you do not want the datum line, which is masking the
fact that the other 2 lines are still continuous.
Without the datum you will need to include empty points in the addition
series to cause the lines to have gaps.

You might find this approach more manageable, which is to highlight the
specific points along the line rather than a segment of the line.
http://peltiertech.com/Excel/Charts/FormatMinMax.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"andy" wrote in message
...
Is it possible to change the line width (or color) based on a if-then
statment?
For example: if the value of one line if hitting new lows for the day but
the value of another line is not hitting new lows for the day is it
possible
to change the width or color of the first line because this condiition is
false?
Thanks!