make selected city different color - bubble graph

[jw01]

hello

in the attached graph, i have the map showcasing items sold per city at different times of the period.

i have created a drop down list, and i was wondering if i can get some help making the graph go "red" or different color than the rest of the graph, when i select a city from the drop down list.....im out of ideas and ways, so i would be grateful if someone can help me with this matter.

(i.e. if i select "new orleans" from the drop down, is it possible to make "new orleans" only go red?

thxs, cheers

[jw01]

hello, any suggestions?! thxs

[Andy Pope]

Just add a new series with the 3 values for the selected item, use any 3 cells with the following INDEX formula.

X value formula =INDEX($C$56:$F$107,$P$4,2)
Y value formula =INDEX($C$56:$F$107,$P$4,1)
Size formula =INDEX($C$56:$F$107,$P$4,4)

[jw01]

hello great, thxs andy,

can i kindly and pls get ur assistance on my final request/graph. having a very similar issue; id be grateful.

http://www.excelforum.com/excel-gene...ith-graph.html