Creating a bullet chart
A bullet chart allows us to visualize progress in a small, concise graph. This chart borrows from thermometers and progress bars, and is typically used to show goals vs actuals.
In this recipe, we will create a bullet chart that shows the comparison between field goals attempted and field goals made by Phoenix Suns players in the NBA 2009 season.
Getting ready
To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called Bullet Chart, 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 bullet 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 formula that concatenates...
