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

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...
主站蜘蛛池模板: 德格县| 溧水县| 巴南区| 梅河口市| 巴林右旗| 邯郸市| 柳林县| 尼勒克县| 盈江县| 大名县| 志丹县| 江永县| 剑川县| 安吉县| 邳州市| 万盛区| 本溪| 吉首市| 黎城县| 湘乡市| 故城县| 罗田县| 客服| 横峰县| 乌拉特后旗| 错那县| 长垣县| 韩城市| 专栏| 孝义市| 宁德市| 休宁县| 扎兰屯市| 陈巴尔虎旗| 嫩江县| 方正县| 鄂托克旗| 正蓝旗| 孟连| 大邑县| 盐源县|