View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Highlight Data points on chart

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