* What the book covers: Covers basic and advanced features of Excel charts. Beginning by explaining Excel's built-in charting features, Excel Charts gives advice on which type of chart to select for your category of data, how to modify data in the chart and deal with missing data, formatting charts, using and customizing shape, and tips on making charts presentable and professional. The book also covers customized and user-defined charts with information on creation, storage, and presentation of the charts. Information is provided on utilizing trend lines, and creating charts from pivot tables. Provides the reader with the basics of creating and modifying charts with VBA. The books covers using the AutoShapes feature, importing pictures and graphics, and creating unique charts by embedding graphics in the chart.
* Version coverage: Excel Charts pays particular attention to the new Excel charting features provided in version 2007.
ABOUT THE CD-ROM
* Includes over 200 example charts and graphs from the book.
Reihe
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.6 cm
Breite: 18.7 cm
Dicke: 3 cm
Gewicht
ISBN-13
978-0-470-04400-1 (9780470044001)
Schweitzer Klassifikation
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.
Autor*in
J-Walk and Associates, Inc., San Diego, CA
Introduction. 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. Index. End-User License Agreement.
