Excel 2007 charts
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...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley
c2007.
|
| Edición: | 1st edition |
| Colección: | Mr. Spreadsheet's Bookshelf
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627554106719 |
Tabla de Contenidos:
- 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
