I have a sheet with site name and associated values.
Site1 100 Site2 123 Site3 432 ... Site20 234
and this is represented in a column/bar chart.
there is a dropdown list of the site names. when the user selects a site, I want the associated row/column in the chart is highlighted... (change colour)
is that possible?