官术网_书友最值得收藏!

Using a combination chart

With the combination chart you can use both columns and lines to visualize data in one single chart.

Getting ready

Open a new file in SAP BusinessObjects Dashboards and enter the data, as shown in the following screenshot, into the spreadsheet:

Getting ready

In the Number section of the Home tab of the toolbar, use the % option to convert the market share values into percentages:

Getting ready

How to do it...

  1. Drag a Combination Chart component to the canvas.
  2. Bind the Chart field to cell A1 and the Subtitle field to cell B2.
  3. Bind the By Range field to the spreadsheet range from A4 to E6.
  4. Select By Series and select the Market share series. Select the option to Plot Series On: Secondary Axis:
    How to do it...
  5. As you can see now, both axes are populated with values:
    How to do it...

How it works...

After binding the data to the component, we adjusted 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.

There's more...

In the Series sub-tab within the Appearance tab of the properties pane, you can determine how each series will appear: either as a column or a line. Here, you can also set the series colors and marker Shape, Marker Size, and Transparency as shown in the following screenshot:

There's more...
主站蜘蛛池模板: 永登县| 甘南县| 宜兰县| 扎兰屯市| 鱼台县| 玉林市| 梅州市| 叙永县| 宁陕县| 柘城县| 将乐县| 彭水| 酒泉市| 雷山县| 汝城县| 墨玉县| 保靖县| 博野县| 全州县| 论坛| 新巴尔虎右旗| 讷河市| 伊宁市| 鄂尔多斯市| 宜良县| 泊头市| 宣恩县| 定结县| 怀柔区| 丽水市| 江达县| 辽宁省| 繁峙县| 平和县| 汝城县| 西充县| 海安县| 临澧县| 江山市| 改则县| 建湖县|