Making charts with excel is part of the job. In order to make the charts more intuitive to reflect the data, many editors often create PivotTable in Excel 2016, but many friends are not clear about how to…