A sample VBA project illustrating automated data manipulation for desired data display. (http://hdesk.pcriot.com) The following was done manually: Populating the raw (base) data The following was done programmatically Generation of the pivot tables Charting of data to area-chart Presentation-ready formatted table replica http://hdesk.pcriot.com