Creating a combo chart (dual axis chart)

A dual axis chart is a chart that uses two axes for two different measures. This chart is useful when two measures have different types or ranges (for example, monetary value and percentage), or if the two measures need to be displayed differently (for example, one as a bar and one as a line).

In this recipe, we will create a dual axis chart, also often referred to as a combo chart.

Getting ready

To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called Combo Chart Dual Axis, and connect to the Player Stats (NBA Players Regular Season 2009) data source.

How to do it...

The following are the steps to create a combo chart (dual axis chart):

1. From Dimensions, drag Team Name to the Filters shelf.
2. Under the General tab, check Suns.
3. From Dimensions, drag Year to the Filters shelf.
4. Under the General tab, choose 2009.
5. From Dimensions, drag League to the Filters shelf.
6. Under the General tab, check N for NBA.
7. If it doesn't exist yet, create...