ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Formatting of Scatter Charts (https://www.excelbanter.com/excel-programming/316287-conditional-formatting-scatter-charts.html)

Krishna@Citigroup

Conditional Formatting of Scatter Charts
 
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


Tom Ogilvy

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





All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com