Hi All,
I have a worksheet with a chart for all resources. The chart has three benchmarks (BM1, BM2 and BM3) - horizontal lines running across the chart in different colors.
Now I installed four buttons below the chart. When I click on a button, the series values should be filtered as per the caption of the button and the chart automatically displays the filtered values. But it retains the Benchmark values as earlier. The chart title should change appropriately.
For example, if I actuate "Yellow" button, the values get filtered by the Group column and those will be the series values for the new chart. I do not want this to display as a new chart, but change the display in the present chart.
I have a task of producing charts for all groups and individual groups. And I have many types of resources in other worksheets. It is a pain generating individual charts and adding benchmarks for each chart.
Any help will be appreciated.