Charts and Graphs for Microsoft Office Excel 2007

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.

This book shows you how to coax Excel to create many charts you might not have believed were possible. You’ll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You’ll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart–without any limitations. You’ll 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 bars–or 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 can’t create with Excel
*Understand what a Radar chart is and when you might use it
*Summarize a million rows of data in a single pivot table chart
*Present data graphically without charts
*Employ SmartArt graphics to show process or relationship charts
*Utilize VBA to create charts
*Put your data on a map
*Export your charts to the web or PowerPoint
*Detect chart lies

Introduction
1 Introducing Charts in Excel 2007
2 Customizing Charts
3 Creating Charts That Show Trends
4 Creating Charts That Show Differences
5 Creating Charts That Show Relationships
6 Creating Stock Analysis Charts
7 Advanced Chart Techniques
8 Creating and Using Pivot Charts
9 Presenting Data Visually Without Charts
10 Presenting Your Excel Data on a Map Using Microsoft MapPoint
11 Using SmartArt Graphics and Shapes
12 Exporting Your Charts for Use Outside of Excel
13 Using Excel VBA to Create Charts
14 Knowing When Someone Is Lying to You with a Chart
Appendix A: Charting References
Index

In case a password is needed: shadow
File from UPLOADING needs to have an extension ".pdf" added to it in order to be read.

Take look at my blog: http://www.avaxhome.ws/blogs/vaniave
Visite meu blog: http://www.avaxhome.ws/blogs/vaniave