Thread: Highlight Data points on chart
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Highlight Data points on chart
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

Reply With QuoteReply With Quote