How to create pivot chart from two separate Pivot Tables

New Contributor

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.

0 Replies