Hello again everyone! This week we are looking to add Reference Bands to our Scatter Plots in order to “group” together like items. Looking at NBA Players Total Games and Points spread.

Click to view interactive version

Requirements:

  • Dashboard size 920 x 825
  • Players are grouped into 5 bins by Avg Points per Game
    • 10-14, 15-19, 20-24, 25-29 and 30-34+
    • Must create an interactive legend on the top right that can be used in a Dashboard Highlight
  • The “Bands” are based on these bins from the Minimum number of points over X games to the Maximum number of points over X games.
  • The Y Axis (Total Points) is fixed at 17,980 to 39,900 | The X Axis (Games) is fixed at 715 to 1667
  • By default, the Top 10 Players (by points scored) will have Text Labels with their Rank, and name
  • When highlighting players using the Points Bin Legend, only show Text Labels for the players in that bin
  • Players that are marked as “active” should have a circle with an outer ring to separate them from inactive players.

Data from this week comes from Basketball-Reference via Jeff Planter. You can download the aggregated data here

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson, @LukeStanke, and @RodyZakovich.  (Tag @VizWizBI too – he would REALLY love to see your work!)

Also, don’t forget to track your progress using this Workout Wednesday form.

3 Comments

  1. Grace September 6, 2018 at 7:12 pm

    Hi Rody,

    Thanks for sharing! I have a problem with the aggregated data to get the profit bins. Also, taking Jordan as example, the avg points for Jordan is 30.12 in your workbook (ignoring 383 games where pts is null), but the avg points can only be 22 with the aggregated data.

    Could you provide the data used in your workbook? Thanks!

    Reply
  2. Jay February 21, 2019 at 4:44 am

    I need help creating the background, I still read post multiple times but no one posted a clear solution to creating the band. Can you please reach out if you have any solutions, thank you..

    Reply

Leave A Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.