Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting of Bar Charts septimus Charts and Charting in Excel 2 November 6th 09 02:35 AM
Conditional formatting on charts Maglez Excel Discussion (Misc queries) 2 October 9th 08 01:11 PM
VBA Conditional formatting of charts T-bone Charts and Charting in Excel 1 April 23rd 08 09:35 AM
Conditional Formatting for Charts Brian Reilly, MVP Charts and Charting in Excel 3 January 13th 08 01:50 AM
Conditional formatting in Charts? Todd Charts and Charting in Excel 1 January 11th 05 06:32 PM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"