I want to create one bar chart and when I Drill down the bar chart then it should display a Line chart or some other chart.
To achieve this, you can create 2 worksheets-
- 1 bar chart on which you want to click
- Line chart which you want to see upon clicking on the 1st bar chart
Now you can create a dashboard with both the chart and use the first bar chart as a filter. After that, once you click on the bar chart, the corresponding data in the line chart will be shown. If you don’t want the line chart to be shown, you can customize the dashboard action as below-
