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.