I use the method described in your paper quite often. Before I found out
about the Na() option I always just put my false response outside the plot
range. and selected max and min values for the graph. From force of habit,
I still do it this way most of the time.

"Jon Peltier" wrote:

Read about conditional charts, no VBA necessary:

http://peltiertech.com/Excel/Charts/...nalChart1.html

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

Aloysicus wrote:

Hi,

I am trying to figure out how to write a macro for a graph to change a
point if the number falls below 80. Eg, if point a, b, c, d are at 79,
90, 78 & 60, the graphs will change the color of point a, c & d to a
different color.

This is a line graph with many points.

Thanks in advance.
Aloys