Here are some of the articles on Pivot techniques and Charting in Microsoft Access. At the top of each article you will see which collection (gold, silver or bronze) the article belongs to.
The full collections and related download files can be purchased here.
Plus these articles on
Exploring Your Data Visually Garry's first ever article
And Office 2007 Articles From The Toolbox Here