After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007.This book will teach users to develop their skills so they can produce great looking charts that communicate clearly.
Brilliant Excel Charts and Graphs teaches techniques that enable users to discard the Microsoft defaults and create charts that can communicate effectively. The first section explains how to decide which chart type to use and subsequent chapters walk through each of the chart types, how to create them, how to utilize them and special options available for each chart . Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users
Sprache
Verlagsort
Verlagsgruppe
Pearson Education Limited
Maße
Höhe: 234 mm
Breite: 185 mm
Dicke: 30 mm
Gewicht
ISBN-13
978-0-273-71404-0 (9780273714040)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Bill Jelenis Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and as an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 12 million page views annually and his daily video podcast is regularly in the top tech podcasts in iTunes.
Michael Alexanderis a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently heads an analytical services group for a $700-million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.
Introduction
Introducing Charts in Excel 2007
Customizing Charts
Creating Charts That Show Trends
Creating Charts That Show Differences
Creating Charts That Show Relationships
Creating Stock Analysis Charts
Advanced Chart Techniques
Creating and Using Pivot Charts
Presenting Data Visually Without Charts
Presenting Your Excel Data on a Map Using Microsoft MapPoint
Using SmartArt Graphics and Shapes
Exporting Your Charts for Use Outside of Excel
Using Excel VBA to Create Charts
Knowing When Someone Is Lying to You with a Chart
A Charting References
Index
