To filter my data, I will click the “Options” button that appears beside the “PlayerName” field and click “Filter(s).”
In order to show the six players with the most attempts on target, I need to click the “Rank” checkbox, select “Top” from the drop-down list box for the “Mode” option, and change the “Count” option to 6. Finally, I need to change the “Column” drop-down list box to “Attempts On Target.”
Now, my widget’s data is far easier to read; however, I would like to make a few additional changes.
First, I would like to replace the percentage values on my widget with numeric values. Second, I would like to make my widget display a legend so I can see which color represents which player without hovering over the player’s pyramid segment. I can make both of these modifications in the “Properties” tab.
After I click the widget’s “Options” button and navigate to the “Properties” tab, I see a section titled “Basic Settings.”
In this section, I can click the checkbox beside the “Show Legend” option to make my widget display a guide demonstrating which segment color is associated with which player.
I can also change the “Data Label” drop-down list box option to “Value” in order to make my pyramid display numeric values instead of percentages.
Now, my pyramid widget looks the way I want it to look; it displays the numeric value of each player’s assists, and it contains a color-coded legend demonstrating which pyramid segment represents each player.
It is worth noting that if you would like to create a funnel chart widget, you can do so using exactly the same steps that are outlined above. The only difference between the pyramid widget and the funnel widget is that the pyramid widget displays values in a progressively increasing manner while the funnel widget showcases values in a progressively decreasing manner.