Creating a bar in bar chart
A bar in bar chart stacks one bar chart on top of the other. Typically the two bars will have different colors and widths. Bar in bar charts can be effective in showing progress to a goal, or any two measures from the same starting point. In this recipe, we will compare the field goals made and attempted by the Phoenix Suns players in 2009 using a bar in bar chart.
Getting ready
To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called Bar in Bar, 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 bar in bar chart:
From Dimensions, drag Team Name to the Filters shelf.
Under the General tab, check Suns.
From Dimensions, drag Year to the Filters shelf.
Under the General tab, choose 2009.
From Dimensions, drag League to the Filters shelf.
Under the General tab, check N for NBA.
If it doesn't exist yet, create a calculated field called Player Name, and provide the following...
