Actions from chart in worksheet to another worksheet

Question

How to add actions from chart in worksheet to another worksheet? When a chart is clicked, i want to use that bar as a value to display in another sheet.

Answer 1

Hi Sindhu,

Follow below steps:

1. Press Ctrl+shift+A, then a action dialog box opens, click on filter under add action drop down at the bottom of the window.

2. Select the source, target sheet and select the filter field and click ok.

3. Now click on the chart then it will filter from sheet 12.

Hope this helps you.