Is it possible to highlight points meeting a condition on a chart? Assume the chart is a line graph..

For example, say you have a series with a default color of black and the y scale is 0 - 100.
Q) How would one highlight values on the y-axis above 80 by changing the color to red??

Joe

Hi
probably not quite what you're looking for but maybe this gives you an
idea how to conditional change the color of a line
http://andypope.info/charts/conditionalline.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Joe wrote:
Is it possible to highlight points meeting a condition on a chart?
Assume the chart is a line graph...

For example, say you have a series with a default color of black and
the y scale is 0 - 100.
Q) How would one highlight values on the y-axis above 80 by changing
the color to red???

Joe

Hi Joe,

This example may help.
(http://www.andypope.info/charts/conditionalline.htm)

Cheers
Andy

Joe wrote:

Is it possible to highlight points meeting a condition on a chart? Assume the chart is a line graph...

For example, say you have a series with a default color of black and the y scale is 0 - 100.
Q) How would one highlight values on the y-axis above 80 by changing the color to red???

Joe

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info