Switching between different charts

This recipe will show you how to create a dashboard with the option of switching between two charts.

Getting ready

Open a new SAP BusinessObjects Dashboards file and drag two different chart components (for example, a Line Chart and a Pie Chart component) into the empty canvas. Drag the Label Based Menu component found in Selectors into the canvas as well.

How to do it...

1. Click on the Line Chart component and go to the Behavior tab of its properties pane. At the bottom of the pane, you will see a section called Dynamic Visibility.

2. Bind the Status field to spreadsheet cell B1.

3. Put value 1 in the Key field:

   

4. Click on the Pie Chart component and go to the Behavior tab.

5. Here also, bind the Status field to cell B1.

6. In the Key field, fill in the value 2:

   

7. Go to the spreadsheet and type Status: in cell A1 and put value 1 in cell B1:

   

8. Now click on the Label Based Menu component and go to the General tab of its properties pane.

9. To set the Labels, click on the button on the extreme...