Excel 2007 charts / John Walkenbach.

Format:

Book

Author/Creator:

Walkenbach, John.

Series:

Mr. Spreadsheet's Bookshelf

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Charts, diagrams, etc--Computer programs.

Charts, diagrams, etc.

Electronic spreadsheets.

Physical Description:

1 online resource (578 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, Ind. : Wiley, c2007.

Language Note:

English

System Details:

text file

Summary:

Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these 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, construct "impossible" charts, create charts from pivot tables, dress them up with graphics, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Contents:

Excel 2007 Charts; About the Author; Acknowledgments; Contents at a Glance; Contents; Introduction; What You Should Know; What You Should Have; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; About the Power Utility Pak Offer; Reach Out; Part I: Chart Basics; Chapter 1: Introducing Excel Charts; What Is a Chart?; How Excel Handles Charts; Parts of a Chart; Basic Steps for Creating a Chart; Working with Charts; Chapter 2: Understanding Chart Types; Conveying a Message with a Chart; Choosing a Chart Type; Excel's Chart Types; Creating Combination Charts

Creating and Using Chart TemplatesChapter 3: Working with Chart Series; Specifying the Data for Your Chart; Adding a New Series to a Chart; Deleting a Chart Series; Modifying the Data Range for a Chart Series; Understanding Series Names; Adjusting the Series Plot Order; Charting a Noncontiguous Range; Using Series on Different Sheets; Handling Missing Data; Controlling a Data Series by Hiding Data; Unlinking a Chart Series from Its Data Range; Working with Multiple Axes; Chapter 4: Formatting and Customizing Charts; Chart Formatting Overview; Adjusting Fills and Borders: General Procedures

Formatting Chart Background ElementsFormatting Chart Series; Working with Chart Titles; Working with a Chart's Legend; Working with Chart Axes; Working with Gridlines; Working with Data Labels; Working with a Chart Data Table; Formatting 3-D Charts; Chapter 5: Working with Trendlines and Error Bars; Working with Trendlines; Linear Trendlines; Nonlinear Trendlines; Displaying a Moving Average; Using Error Bars in a Chart Series; Other Series Enhancements; Chapter 6: Working with Shapes and Other Graphics; Using Shapes; Working with SmartArt; Using WordArt; Working with Other Graphic Types

A Gallery of Graphic ExamplesPart II: Mastering Charts; Chapter 7: Creating Interactive Charts; Introducing Interactive Charts; Hands-On: Creating a Self-Expanding Chart; Controlling a Series with a Scroll Bar; Specifying the Beginning and End Point for a Series; Specifying the First Point and Number of Points for a Series; Plotting the Last; Data Points in a Series; Plotting Every; Data Point in a Series; Using Check Boxes to Select Series to Plot; Creating a Very Interactive Chart; Chapter 8: Charting Techniques and Tricks; Adding Lines and Backgrounds to a Chart

Charts That Use a Single Data PointUsing a Dummy Axis; Column and Bar Chart Variations; Creating a Timeline; Creating "Impossible" Charts by Stacking and Overlaying; Displaying Multiple Charts on a Chart Sheet; Chapter 9: In-Cell Charting Techniques; Visualizing Data with Conditional Formatting; Plotting Data without a Chart; Creating Sparkline Charts; Chapter 10: Mathematical and Statistical Charting Techniques; Drawing a Circle with an XY Series; Connecting Scatter Chart Data Points to the Axes with Error Bars; Connecting XY Points to the Origin

Creating Frequency Distributions and Histograms

Notes:

Includes index.

Description based on online resource; title from title page (ebrary, viewed May 22, 2013).

ISBN:

9780470230343

0470230347

9781118050842

1118050843

OCLC:

811499837