Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

Table of Contents (26 chapters)
SAP BusinessObjects Dashboards 4.1 Cookbook
Credits
Foreword
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

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:

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

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:

  5. As you can see now, both axes are populated with values:

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...