75% Complete


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!

Explore data and gain insights with PivotTable: product sales in different markets

Explore data with PivotTable: car reservations

Use PivotChart to draw histograms