Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel 2007 Chart Markers - Setting Colours based on criteria
3 views
Skip to first unread message
Karen
Apr 6, 2010, 10:23:01 AM4/6/10
to
I am new to using VBA code in Excel and would like to know how to set the
colour of a marker on a Scatter chart based on the value of one cell in the
source table.
colour of a marker on a Scatter chart based on the value of one cell in the
source table.
I am trying to set the colour of the marker to red if value is <4, yellow if
value is between 4 and 7 and green if value is between 7 and 10.
Any ideas regarding the type of macro code required would be appreciated.
Thanks,
0 new messages