Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How to create pivot chart from two separate Pivot Tables

Copper 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