-
Book Overview & Buying
-
Table Of Contents
SAP BusinessObjects Dashboards 4.0 Cookbook
By :
With the combination chart you are able to use both columns and lines to visualize data in one single chart.
Open a new Dashboard Design file and enter the data into the spreadsheet as shown in the following screenshot:

Use the Percent Style option to convert the market share values into percentages. You can find this option in the Number section of the Home tab of the toolbar.

Drag a Combination Chart component to the canvas.
Bind the Chart field to cell A1 and the Subtitle field to cell B2.
Bind the By Range field to the spreadsheet range from A4 to E6.
Select By Series and select the Market Share series. Select the option to Plot Series On: Secondary Axis.

After binding the data to the component, we had to adjust the Market Share series to plot its data on the secondary axis. After doing this, a second y-axis appeared on the right-hand side of the chart, labeled with percentages.
In the Series sub-tab within...
Change the font size
Change margin width
Change background colour