Home > Store > Home & Office Computing > Microsoft Applications
Charts and Graphs for Microsoft Office Excel 2007
- By Bill Jelen
- Published Apr 24, 2007 by Que. Part of the Business Solutions series.
- Copyright 2007
- Dimensions: 7x9-1/8
- Pages: 480
- Edition: 1st
- Book
- ISBN-10: 0-7897-3610-1
- ISBN-13: 978-0-7897-3610-9
- eBook (Adobe DRM)
- ISBN-10: 0-7686-7484-0
- ISBN-13: 978-0-7686-7484-2
Register your product to gain access to bonus material or receive a coupon.
Product Author Bios
Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.
<>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 possibilities–a 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. 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
ABOUT THE AUTHOR
Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.
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
Downloads
Download the data files used in this book to work along with the samples or view the charts in color.
ChartingAll.zip (53 MB)
|
5 of 5 people found the following review helpful
Great book to teach you a whole lot of Excell Graphing trick, By
Amazon Verified Purchase(What's this?)
This review is from: Charts and Graphs for Microsoft Office Excel 2007 (Paperback)
I learn a whole lot just by leafing through the book. Highly recommended. Many weird problems (like who to plot hours which isn't natively supported in Excel) are shown how to workaround.
7 of 8 people found the following review helpful
Okay book, butprobably should include a CD, By
Amazon Verified Purchase(What's this?)
This review is from: Charts and Graphs for Microsoft Office Excel 2007 (Paperback)
This is a good book from the standpoint of detailing the changes from previous versions of Excel. However, if you want to follow along with the book using Excel on your computer, be ready for lots of typing to input the data to create the charts and graphs shown in the book.I consider the book more of a reference document to look up some element of Excel 2007 that I don't understand or that needs further explanation. A CD with the data files would have been a big help to use to follow along with the book, or maybe be able to download the files online. Admittedly, the book description did not mention a CD, so I only have myself to blame.
3 of 3 people found the following review helpful
Excel charting missing manual, By
This review is from: Charts and Graphs for Microsoft Office Excel 2007 (Paperback)
Mr. Jelen really teaches what he has promised. He follows a very intuitive approach to book writing that reminds me of the GUI interface lemma: "Don't make me think".However I would appreciate a link to a place where I could download the examples in the book. |
Online Sample Chapter
Creating Excel 2007 Charts That Show Trends
Table of Contents
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
Downloadable Sample Chapter
Index
Introduction
This book includes free shipping!
This book includes free shipping!
eBook (Adobe DRM)
$31.99
$25.59
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
