How to Build Interactive Dashboard (Sales by Managers) Problem |Power Pivot|Excel Forum|My Online Training Hub

So in the video, when she pivot charts the sales by manager bar graph, the states are omitted from having their own bars and acts a section divider for the managers. But in my graph, the states are represented by their own bar graph and their bar is considerably larger than any of the managers making it difficult to compare managers. Please help, Thank you. I want to add that I am currently using Excel 2017. I guess what I'm really trying to say is that in all of her graphs in the video grand total is omitted from all graphs while in mine, grand total is in all the pivot charts. Also pivot chart/table is unavailable in excel 2017 so I have to go into the insert tab and click recommended charts. Thank you again.