1 Reply Latest reply on Mar 2, 2012 10:10 AM by Tracy Rodgers

    highlight data

      Hi there,

       

      I have a dashboard which combines two sheets of data.

       

      Sheet 1 is a table layout with date going down the y axis and the corresponding data in the columns next to it.

      Sheet 2 is a bar chart view of the data in the table.

       

      If I select data in the table - I would like it to highlight the respective bar in the bar chart and vice versa. I do not want it to filter the data - simply highlight what is selected much like it does when you click on a bar in a single sheet and all of the bars in the other charts are highlighted. The difference here is that the data sets are coming from different sheets and one is a table and the other a bar chart.

       

      Any thoughts?

       

      Thanks,

      Ryan