How change value in a chart using dropdown menu

Originally Posted by FrancisM2411

Thanks Avk, this is good. One other question off topic, i had with regards to graphs, I've come across a line graph where it has a numbr of lines and all are grayed out. there is a dropdown and when they selet a heading, one of the lines changes colour whist the other lines remain gray. Wuld you happend to know how I can achieve that format on a graph? thanks

Dear Fancis, this is another issue. plz post thread separatly.
Secondly, If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".