Charts and Graphs for Microsoft Office Excel 2007 (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
480
Utgivningsdatum
2007-04-01
Upplaga
1
Förlag
QUE
Illustrationer
Illustrations
Dimensioner
230 x 175 x 30 mm
Vikt
740 g
Antal komponenter
1
ISBN
9780789736109
Charts and Graphs for Microsoft Office Excel 2007 (häftad)

Charts and Graphs for Microsoft Office Excel 2007

Char Grap MS Off Excel2007_p1

Häftad Engelska, 2007-04-01
359
Skickas inom 3-6 vardagar.
Fri frakt inom Sverige för privatpersoner.
<>It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.

 

More than a how-to and reference, this book also provides the why-tos and when-tos, with serious consideration given to layout best practices and design possibilitiesa very well-rounded resource.

Kathy Villella, CEO, PowerFrameworks.com

  • Implementing 1-Click Charting
  • Incorporating Drag & Drop and Dynamic Charts
  • Creating Amazing Effects
  • Using Charting Templates and Macros
  • Mastering Glow, Shadow, Sparklines, Dashboards, and More
  • Eliminating Chart Junk
  • Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts
  • Develop your Charting expertise instantly with proven techniques
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. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to make it look great.

 

This book shows you how to coax Excel to create many charts you might not have believed were possible. Youll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. Youll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chartwithout any limitations. Youll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data barsor even the decades-old REPT function!

 

In no time, this book will have you creating charts that wow your audience and effectively communicate your message.

  • Master effective visual display of data
  • Choose the right chart type to convey your message
  • Learn time-saving workarounds
  • Create charts that most people think you cant create with Excel
  • ...
Visa hela texten

Passar bra ihop

  1. Charts and Graphs for Microsoft Office Excel 2007
  2. +
  3. Engineering Design Graphics with Autodesk Inventor 2015

De som köpt den här boken har ofta också köpt Engineering Design Graphics with Autodesk Inven... av James D Bethune (häftad).

Köp båda 2 för 1698 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Bloggat om Charts and Graphs for Microsoft Office Ex...

Övrig information

Bill Jelen, Microsoft MVP for Excel, is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com. 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. Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and VB.Net. He currently lives in Plano, TX where heads an analytical services department for a $700 million company, and has written numerous articles at the www.DataPigTechnologies.com website.

Innehållsförteckning

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1

1 Introducing Charts in Excel 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2 Customizing Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37

3 Creating Charts That Show Trends . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

4 Creating Charts That Show Differences . . . . . . . . . . . . . . . . . . . . . . 121

5 Creating Charts That Show Relationships . . . . . . . . . . . . . . . . . . . . 147

6 Creating Stock Analysis Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187

7 Advanced Chart Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223

8 Creating and Using Pivot Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267

9 Presenting Data Visually Without Charts . . . . . . . . . . . . . . . . . . . . . 281

10 Presenting Your Excel Data on a Map Using Microsoft MapPoint . 307

11 Using SmartArt Graphics and Shapes . . . . . . . . . . . . . . . . . . . . . . . . 317

12 Exporting Your Charts for Use Outside of Excel . . . . . . . . . . . . . . . . 347

13 Using Excel VBA to Create Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . 357

14 Knowing When Someone Is Lying to You with a Chart . . . . . . . . . 423

Appendix A: Charting References . . . . . . . . . . . . . . . . . . . . . . . . . . . 431

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439