View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Conditional Formatting of Scatter Charts

Iterate over the points collection and check your condition. Take
appropriate action.

Turn on the macro recorder and format a point manually to get the basic
code.

--
Regards,
Tom Ogilvy

"Krishna@Citigroup" wrote in
message ...
Hi,
I have a scatter chart and need to conditionally format points and
associated labels for each point. The condition is not related to the data
series to which the chart is linked.
Let me know if there is any specific VBA code for doing the same. You can
reach me at