First of all I would like to thank you for further comments and reading my question!
I am really Need in your help!
I created a Chart by using Pivot table.The Chart Shows the Name of the products and Revenue for each of this products.
Could you please help me,how can i do in VBA or by another method,I want to choose the one product,press on it,and it will be automatically Shows on the graph by changing Color only of the bar of this specific product ?
for example,all columns are Grey,then i will choose on product,and this product will be automatically Shows by red on the chart
I am really appreciate your help!I am very tried to explain...