{"product_id":"9780789736109","title":"Charts and Graphs for Microsoft Office Excel 2007","description":"\u0026lt;\u0026gt;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. \u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e“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.”\u003c\/p\u003e\u003cp\u003e\u003cb\u003e–Kathy Villella, CEO, PowerFrameworks.com\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Implementing \u003cb\u003e1-Click Charting\u003c\/b\u003e \u003c\/li\u003e \u003cli\u003e Incorporating \u003cb\u003eDrag \u0026amp; Drop \u003c\/b\u003eand \u003cb\u003eDynamic \u003c\/b\u003eCharts \u003c\/li\u003e \u003cli\u003e  \u003cb\u003eCreating \u003c\/b\u003eAmazing \u003cb\u003eEffects\u003c\/b\u003e \u003c\/li\u003e \u003cli\u003e Using \u003cb\u003eCharting Templates \u003c\/b\u003eand \u003cb\u003eMacros\u003c\/b\u003e \u003c\/li\u003e \u003cli\u003e Mastering \u003cb\u003eGlow\u003c\/b\u003e, \u003cb\u003eShadow\u003c\/b\u003e, \u003cb\u003eSparklines\u003c\/b\u003e, \u003cb\u003eDashboards\u003c\/b\u003e, and More \u003c\/li\u003e \u003cli\u003e Eliminating \u003cb\u003eChart Junk\u003c\/b\u003e \u003c\/li\u003e \u003cli\u003e Structuring Spreadsheets with \u003cb\u003eBusiness Diagrams\u003c\/b\u003e, \u003cb\u003eSmartArt \u003c\/b\u003eGraphics, and \u003cb\u003ePivot \u003c\/b\u003eCharts \u003c\/li\u003e \u003cli\u003e  \u003cb\u003eDevelop \u003c\/b\u003eyour \u003cb\u003eCharting \u003c\/b\u003eexpertise \u003cb\u003einstantly \u003c\/b\u003ewith proven \u003cb\u003etechniques\u003c\/b\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAfter 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis 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!\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIn no time, this book will have you creating charts that wow your audience and effectively communicate your message.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Master effective visual display of data \u003c\/li\u003e \u003cli\u003e Choose the right chart type to convey your message \u003c\/li\u003e \u003cli\u003e Learn time-saving workarounds \u003c\/li\u003e \u003cli\u003e Create charts that most people think you can’t create with Excel \u003c\/li\u003e \u003cli\u003e Understand what a Radar chart is and when you might use it \u003c\/li\u003e \u003cli\u003e Summarize a million rows of data in a single pivot table chart \u003c\/li\u003e \u003cli\u003e Present data graphically without charts \u003c\/li\u003e \u003cli\u003e Employ SmartArt graphics to show process or relationship charts \u003c\/li\u003e \u003cli\u003e Utilize VBA to create charts \u003c\/li\u003e \u003cli\u003e Put your data on a map \u003c\/li\u003e \u003cli\u003e Export your charts to the web or PowerPoint \u003c\/li\u003e \u003cli\u003e Detect chart lies \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e \u003cb\u003eABOUT THE AUTHOR\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003cb\u003eBill Jelen \u003c\/b\u003eis 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 \u003ci\u003eThe Lab \u003c\/i\u003eon 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003e \u003cbr\u003e \u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIntroduction \u003c\/p\u003e\u003cp\u003e1 Introducing Charts in Excel 2007 \u003c\/p\u003e\u003cp\u003e2 Customizing Charts \u003c\/p\u003e\u003cp\u003e3 Creating Charts That Show Trends \u003c\/p\u003e\u003cp\u003e4 Creating Charts That Show Differences \u003c\/p\u003e\u003cp\u003e5 Creating Charts That Show Relationships \u003c\/p\u003e\u003cp\u003e6 Creating Stock Analysis Charts \u003c\/p\u003e\u003cp\u003e7 Advanced Chart Techniques \u003c\/p\u003e\u003cp\u003e8 Creating and Using Pivot Charts \u003c\/p\u003e\u003cp\u003e9 Presenting Data Visually Without Charts \u003c\/p\u003e\u003cp\u003e10 Presenting Your Excel Data on a Map Using Microsoft MapPoint \u003c\/p\u003e\u003cp\u003e11 Using SmartArt Graphics and Shapes \u003c\/p\u003e\u003cp\u003e12 Exporting Your Charts for Use Outside of Excel \u003c\/p\u003e\u003cp\u003e13 Using Excel VBA to Create Charts\u003c\/p\u003e\u003cp\u003e14 Knowing When Someone Is Lying to You with a Chart \u003c\/p\u003e\u003cp\u003eAppendix A: Charting References \u003c\/p\u003e\u003cp\u003eIndex\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Que","offers":[{"title":"Default Title","offer_id":47016050262256,"sku":"9780789736109","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780789736109_p0.jpg?v=1763808263","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780789736109","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}