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
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