Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
1  
Take a look at This article at Chandoo.org. –  Detnuomnu Jun 21 '13 at 7:19

1 Answer 1

up vote 2 down vote accepted

One possible way to do this is with two helper columns and a stacked column (or bar) chart.

You need a data table where the selected site is plotted in a different series. The series to be highlighted is selected in cell G1.

In the example below, the original data values are in column B. The formula in C2 is

=IF(A2<>$G$1,B2,0)

The formula in D2 is

=IF(A2<>$G$1,0,B2)

Copy both formulas down to row 21. Then build a stacked column chart with two series from columns C and D and x axis labels from column A.

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.