PivotTable is a powerful tool that savvy business analysts cannot live without. It provides an interactive environment for summarizing and exploring data, where insights can then be harvested.
PivotTable can also be used to plot distribution charts (or so called histogram or frequency charts). This method is better than Excel's own Histogram tool under Data Analysis. We illustrate this below with an example.
Please use the comment section below to post your questions and thoughts!