Sometimes you have a small space in Excel to display your data. However you may have a lot of records to show. Instead of building this long table or putting them to a chart, you can create a table with a scroll bar. This way you can scroll through hundreds of records in one spot in your spreadsheet.
I take you through getting the data to building the pivot table to setting up the scroll bar to make the table appear moving.
Download the sample file here to follow along: http://bit.ly/excelbyjoe_downloads