Excel Charts For Dummies

by Bluttman, Ken

• ISBN13: 9780764584732
• ISBN10: 0764584731
• Format: Paperback
• Copyright: 2005-06-10
• Publisher: For Dummies

Summary

Excel is the most popular tool for number crunching on the PC, but the challenge is in putting a meaningful face on those raw numbers. That's where Excel Charts For Dummies comes in. Ken Bluttman will show readers how to professionally display data in presentation-quality charts. But he'll go beyond showing readers how to create attractive charts-he'll explain why to use specific charts in particular circumstances. Lots of real-world examples will show "the good, the bad, and the ugly" of Excel charts. He will cover the whole range of charts in step-by-step tutorials-whether it's pies, scatter plots, or PivotCharts. He'll show how to embed graphics and pictures into charts; then use them in impressive PowerPoint presentations or Microsoft Word documents. He'll also show how to use charts for statistical analysis-and how charts can skew the stats and deceive. This book will feature a 16-page full-color insert of the best Excel charts "works of art."

Author Biography

Ken Bluttman has been working as a software developer for over 15 years. He works with many technologies, including Office/VBA, Visual Basic .NET, SQL Server, as well as ASP.NET and other Web goodies. He is the author of Excel Formulas and Functions For Dummies, Access Hacks, and Developing Microsoft Office Solutions.

Table of Contents

Introduction.

Part I: Getting Started with Excel Charts.

Chapter 1: Harnessing the Power of Excel Charts.

Chapter 2: Understanding How Charts Are Constructed.

Chapter 3: Making Great Charts with the Chart Wizard.

Part II: Exploring Chart Types.

Chapter 4: Creating Charts That Compare Items.

Chapter 5: Creating Charts That Show Change.

Chapter 6: Creating Charts That Display Data Relationships.

Chapter 7: Working With Custom Chart Types.

Part III: Formatting Charts.

Chapter 8: Positioning and Sizing Your Charts.

Chapter 9: Formatting the Chart Area, Plot Area, and Gridlines.

Chapter 10: Formatting the Axes’ Patterns, Font, Number Format, and Alignment.

Chapter 11: Working With the Category-Axis Scale Settings.

Chapter 12: Working With the Value-Axis Scale Settings.

Chapter 13: Formatting the Data Series.

Chapter 14: Working With 3-D Views.

Chapter 15: Using AutoShapes and Graphics.

Part IV: Advanced Chart Techniques.

Chapter 16: Adding Trendlines to a Chart.

Chapter 17: Using Combination Charts.

Chapter 18: Creating and Saving User-Defined Charts.

Chapter 19: Creating Pivot Tables and Pivot Charts.

Chapter 20: Interacting with External Programs.

Part V: The Part of Tens.

Chapter 21: Ten Chart Remakes.

Chapter 22: Ten (or So) Fancy Charts.

Index.