Creating a Histogram from a Pivot Table.

 I'll start the PivotTable forum off with a cheap trick.

Did you know you can use a pivot table as the source for a histogram? 

First, you need to create a pivot table where the data values are plotted in the Row area (not the Data area). 

Notice that the SalesAmount field is placed in the Row Labels area.

Next, right-click on any value in the Row area and select Group.
In the Group dialog box, set the start and end values, then set the intervals. This will essentially create your frequency distribution. 

The obvious benefit to this technique is you can interactively filter the data based on other dimensions like Region and Market.