Excel conditional formatting of data labels in excel 2003 XY plot

Joined
Jul 28, 2009
Messages
1
Reaction score
0
Hi
Scanned the web, but didnt arrive at any solution. This is Excel 2003 charting.
I have 4 columns: name, score A, score B, role, and I am plotting each name on XY plot with score A being on x axis and score B on y axis.
While I got the macro coding for assigning data labels so that the name appears as data labels, I am not able to conditionally format the color of the name based on the role played as in column D. So if role played is developer, name should appear as red, or if role is manager, name should appear in green etc

Can someone help me pls
 
Back
Top