I want to open a separate worksheet/dashboard when I click on one bar chart. how to do that
This can be achieved using a dashboard action. We have a dashboard action that helps you navigate to a specific worksheet upon clicking on one chart on the dashboard.
Let’s say you have a dashboard with a chart- category vs sales. Now go to the dashboard and select action. Here follow add action → go to sheet. Here select the sheet on which you want to redirect-
This way you can achieve the requirement.