Charts and Graphs for Microsoft Office Excel 2007
|Author: Bill Jelen|
Publisher: Que Publishing
Sales Rank: 1,744,406
Format: Kindle eBook
Language: English (Published)
Media: Kindle Edition
Publication Date: April 24, 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.
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. 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!
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.Thank you for browsing ExcelBookstore.com!