Nov 15 2022 03:55 PM
Hi I have a set of data that has different players, their pitch types, and traits of their pitch types (Velocity, Movement, etc.). I created two pivot tables to compare the overall avg of all the pitchers velo and the avg of each individual pitchers velo. I'm trying to make a chart that shows the comparison. I tried to make two pivot tables and a regular table to make the chart but not every pitcher throws the same pitches so the rows aren't consistent. I am now trying to use two separate pivot tables for one pivot chart to visualize this comparison but am struggling.
Note: Open to suggestions on a better way to visualize this.