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

Scaling the y-axis


After binding a chart to a dataset in the spreadsheet, SAP BusinessObjects Dashboards makes up a scale on the y axis by default, based on the lowest and highest values in the visualized dataset. The problem with this auto-scaling is that it creates a y-axis that doesn't start with 0, which may cause a bad interpretation of the data.

In the following screenshot, the same results are presented in two bar charts. The chart on the left-hand side gives the indication that Product B has performed a lot better than Product A; the bar is more than two times larger! This is, of course, wrong, as the y-axis starts at $470,000. The chart on the right-hand side shows a version that is much more useful for analysis.

Getting ready

You can reuse any of the dashboards you have already made with chart components. In this recipe, we will use the dashboard created in the Adding a line chart to your dashboard recipe.

How to do it...

  1. Select the chart, go to the Behavior tab, and select the Scale...