+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)


Excel 2007 Charts. Mr. Spreadsheet's Bookshelf

  • ID: 2251101
  • Book
  • October 2007
  • 556 Pages
  • John Wiley and Sons Ltd
1 of 3
Chart your success with data that means something

The top tool for number–crunching now offers a vastly improved charting function to help you give those numbers dimension and relativity. And here′s Mr. Spreadsheet to help you make the most of it.

John Walkenbach clearly explains all of Excel′s charting features and shows you how to choose the right chart for your needs. You′ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, and create charts from pivot tables. You′ll be able to use AutoShapes, dress up your charts with graphics, and more, all with clear direction from the leading Excel expert.

Mr. Spreadsheet′s Chart Toppers

  • Chart Topper # 1 Create high–impact effects
  • Chart Topper # 2 Match your chart to your data

  • Chart Topper # 3 Customize charts with graphics

  • Chart Topper # 4 Construct "impossible" charts

  • Chart Topper # 5 Build interactive charts

Note: Product cover images may vary from those shown
2 of 3

Part I: Chart Basics.

Chapter 1: Introducing Excel Charts.

Chapter 2: Understanding Chart Types.

Chapter 3: Working with Chart Series.

Chapter 4: Formatting and Customizing Charts.

Chapter 5: Working with Trendlines and Error Bars.

Chapter 6: Working with Shapes and Other Graphics.

Part II: Mastering Charts.

Chapter 7: Creating Interactive Charts.

Chapter 8: Charting Techniques and Tricks.

Chapter 9: In–Cell Charting Techniques.

Chapter 10: Mathematical and Statistical Charting Techniques.

Chapter 11: Using Pivot Charts.

Chapter 12: Avoiding Common Chart–Making Mistakes.

Chapter 13: Just for Fun.

Part III: Mastering Charts.

Chapter 14: VBA Overview and Basic Examples.

Chapter 15: Advanced VBA Examples.

Chapter 16: Working with Colors.

Part IV: Appendixes.

Appendix A: What s on the CD–ROM?

Appendix B: Other Charting Resources.


End–User License Agreement.

Note: Product cover images may vary from those shown
3 of 3
John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His forty–plus books include Excel
2007 Power Programming with VBA,
Excel 2007 Formulas, and the bestselling
Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award–winning Power Utility Pak. Visit John′s popular Spreadsheet Page at www.j–walk.com/ss.
Note: Product cover images may vary from those shown