Synopses & Reviews
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.”
SynopsisVeteran author John Nicholson shows Excel users how to display data in presentation-quality charts that are clear and easy to understand Packed with real-world examples, this book covers the entire range of charts including pies, scatter plots, and PivotCharts in step-by-step tutorials Explains how to embed graphics and pictures into charts and then use them in PowerPoint presentations or Microsoft Word documents Addresses how to use charts for statistical analysis and also discusses how charts can sometimes skew data . . . and even deceive A 16-page color insert showcases cutting-edge example charts
Veteran author Nicholson shows Excel users how to display data in presentation-quality charts that are clear and easy to understand. Packed with real-world examples, this book covers the entire range of charts--including pies, scatter plots, and Pivot Charts--in step-by-step tutorials. 16-page color insert.
Develop charts that help you explain the numbers
Choose the right type of chart for your purpose, add graphics, or try 3-D
You've crunched the numbers, but what do they mean? This handy guide helps you chart your way to success by presenting those figures in a form that says something to your audience. Discover options like Radar and Bubble charts, format your charts to grab attention, and even put them into PowerPoint presentations or on the Web.
Discover how to
- Use the Chart Wizard
- Choose the best chart type for your data
- Demonstrate change or relationships
- Format axis lines
- Insert gradients, textures, and patterns
- Create pivot charts and pivot tables
About the Author
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
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.