kevvukeka
02-27-2015, 03:58 AM
Hi All,
I need some help with VBA.
In the attached file, I have a line chart and drop down list on top of it. The line chart contains labels from A to O. The drop down at the top contains the exact labels A to O.
When I select a particular label from the drop down I want the marker of that particular label(which is a circle here) in the chart to be highlighted in "Green" , the rest should be turned into some other color may be grey or any other color other than green.
Can someone help.
Thanks in advance.
I need some help with VBA.
In the attached file, I have a line chart and drop down list on top of it. The line chart contains labels from A to O. The drop down at the top contains the exact labels A to O.
When I select a particular label from the drop down I want the marker of that particular label(which is a circle here) in the chart to be highlighted in "Green" , the rest should be turned into some other color may be grey or any other color other than green.
Can someone help.
Thanks in advance.