In this post I demonstrate how using excel pivot tables and excel charts I created a chart that displays the same data as the monthly transfers by supplier chart from CHEP pallet report website.