Picture 1 of 1
Picture 1 of 1
CHARTS AND GRAPHS FOR MICROSOFT OFFICE EXCEL 2007 By Bill Jelen *Mint Condition*
US $9.99
Approximately£7.47
Condition:
New
A new, unread, unused book in perfect condition with no missing or damaged pages. See the seller's listing for full details.
Postage:
US $5.00 (approx £3.74) Standard Shipping.
Located in: Lake Placid, New York, United States
Delivery:
Estimated between Mon, 30 Sep and Fri, 4 Oct to 43230
Returns:
No returns accepted.
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:232546499215
Item specifics
- Condition
- ISBN
- 9780789736109
- Subject Area
- Computers
- Publication Name
- Charts and Graphs for Microsoft Office Excel 2007
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / Spreadsheets
- Publication Year
- 2007
- Type
- Textbook
- Format
- Perfect
- Language
- English
- Item Height
- 1 in
- Item Weight
- 25.8 Oz
- Item Width
- 6.9 in
- Number of Pages
- 480 Pages
About this product
Product Identifiers
Publisher
Pearson Education
ISBN-10
0789736101
ISBN-13
9780789736109
eBay Product ID (ePID)
57019659
Product Key Features
Number of Pages
480 Pages
Language
English
Publication Name
Charts and Graphs for Microsoft Office Excel 2007
Subject
Desktop Applications / Spreadsheets
Publication Year
2007
Type
Textbook
Subject Area
Computers
Format
Perfect
Dimensions
Item Height
1 in
Item Weight
25.8 Oz
Item Length
9.1 in
Item Width
6.9 in
Additional Product Features
Intended Audience
Trade
LCCN
2007-004763
Dewey Edition
22
Illustrated
Yes
Dewey Decimal
005.54
Table Of Content
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
Synopsis
It is easy to create a bad-looking chart in Excel, so this book teaches how to unlock the beautiful formatting options available in Excel 2007. The authors discuss themes, colors, creating metallic charts, shadows, and transparency, and show how to use the new in-cell data bar charts now available., 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 an
LC Classification Number
HF5548.4.M523
Item description from the seller
Registered as a private seller
Thereby, consumer rights stemming from EU consumer protection law do not apply. eBay buyer protection still applies to most purchases.
Seller Feedback (554)
- f***w (57)- Feedback left by buyer.Past yearVerified purchaseAs described, brand new and still sealed. Shipping was very fast and it was carefully packaged. Nice addition to my collection. Thank you.HUBERT LAWS - In The Beginning - CD - BRAND NEW SEALED - MINT (#232434702033)
- 6***6 (337)- Feedback left by buyer.Past 6 monthsVerified purchasePerfect near-mint condition magazine, quickly delivered. Thank you.
- u***2 (4488)- Feedback left by buyer.Past 6 monthsVerified purchasegreat sellerWomen's BLOCH slip-on office, dance slippers. NEW. Rubber soles SILVER Size 7.5 (#332784786391)
Product ratings and reviews
More to explore:
- Charts Non-Fiction Hardcover Books,
- Non-Fiction Charts Paperback Fiction & Books,
- Non-Fiction Charts Fiction & Non-Fiction Books,
- 9.8 Near Mint/Mint 2007 Publication Year Comics, Graphic Novels & TPBs,
- Bill Pronzini Fiction & Fiction Books,
- 9.8 Near Mint/Mint Comics,
- Bill Granger Cookbooks Fiction & Non-Fiction Books,
- 9.8 Near Mint/Mint Comics, Graphic Novels & TPBs,
- 9.8 Near Mint/Mint Comics 1992 Publication Year,
- Superheroes 9.8 Near Mint/Mint Comics, Graphic Novels & TPBs