John Walkenbach is by far my favorite Excel author (I was honored to have his review on the back of my book!).
This book covers many charting tips and trick, plus advice on the best charts to use and also those to avoid. Includes more advanced topics like interactive and dynamic charts. The later editions of the book that cover the newer versions are just as good.
Great ideas and advice highly recommend. Probably best to buy the later editions as Excel 2007 had a few issues with charts and macros.