Charts and Graphs for Microsoft Office Excel 2007 (Paperback)

Bill Jelen, Michael Alexander

Published by Pearson Education (US), 2007
ISBN 10: 0789736101 / ISBN 13: 9780789736109
Used / Paperback / Quantity Available: 0
Available From More Booksellers
View all  copies of this book

About the Book

We're sorry; this specific copy is no longer available. AbeBooks has millions of books. We've listed similar copies below.

Description:

Language: English . Brand New Book. 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, * 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, . 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. Bookseller Inventory #

About this title:

Book ratings provided by Goodreads:
4 avg rating
(8 ratings)

Synopsis: <>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

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.

"About this title" may belong to another edition of this title.

Bibliographic Details

Title: Charts and Graphs for Microsoft Office Excel...
Publisher: Pearson Education (US)
Publication Date: 2007
Binding: Paperback
Book Condition: New

Top Search Results from the AbeBooks Marketplace

1.

Bill Jelen
Published by Que (2007)
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used First Edition Quantity Available: 1
Seller:
Better World Books
(Mishawaka, IN, U.S.A.)
Rating
[?]

Book Description Que, 2007. Book Condition: Very Good. 1st Edition. Former Library book. Great condition for a used book! Minimal wear. Bookseller Inventory # GRP67582443

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.64
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Bill Jelen
Published by Que (2007)
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used First Edition Quantity Available: 1
Seller:
Better World Books
(Mishawaka, IN, U.S.A.)
Rating
[?]

Book Description Que, 2007. Book Condition: Good. 1st Edition. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP73312411

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.64
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Bill Jelen
Published by Que (2007)
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used First Edition Quantity Available: 1
Seller:
Better World Books: West
(Reno, NV, U.S.A.)
Rating
[?]

Book Description Que, 2007. Book Condition: Good. 1st Edition. Ships from Reno, NV. Former Library book. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP96985741

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.64
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Bill Jelen
Published by Que Publishing
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
Free Shipping Books
(Toledo, OH, U.S.A.)
Rating
[?]

Book Description Que Publishing. Paperback. Book Condition: VERY GOOD. Light rubbing wear to cover, spine and page edges. Very minimal writing or notations in margins not affecting the text. Possible clean ex-library copy, with their stickers and or stamp(s). Bookseller Inventory # 2783838845

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.65
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

5.

Bill Jelen
Published by Que Publishing
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
Hippo Books
(Toledo, OH, U.S.A.)
Rating
[?]

Book Description Que Publishing. Paperback. Book Condition: GOOD. Spine creases, wear to binding and pages from reading. May contain limited notes, underlining or highlighting that does affect the text. Possible ex library copy, that’ll have the markings and stickers associated from the library. Accessories such as CD, codes, toys, may not be included. Bookseller Inventory # 2820971539

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.65
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Bill Jelen
Published by Pearson Education
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 2
Seller:
Rating
[?]

Book Description Pearson Education. Paperback. Book Condition: Very Good. Very good condition - book only shows a small amount of wear. Bookseller Inventory # G0789736101I4N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.89
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

7.

Bill Jelen
Published by Pearson Education
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Blue Cloud
(Phoenix, AZ, U.S.A.)
Rating
[?]

Book Description Pearson Education. Paperback. Book Condition: Fair. Bookseller Inventory # G0789736101I5N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.89
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

8.

Bill Jelen
Published by Pearson Education
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Green Earth
(Portland, OR, U.S.A.)
Rating
[?]

Book Description Pearson Education. Paperback. Book Condition: Good. Light shelving wear with minimal damage to cover and bindings. Pages show minor use. Bookseller Inventory # G0789736101I3N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.89
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

9.

Bill Jelen
Published by Pearson Education
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Atlanta Book Co.
(Atlanta, GA, U.S.A.)
Rating
[?]

Book Description Pearson Education. Paperback. Book Condition: Good. Ex-Library Book - will contain Library Markings. Book shows minor use. Cover and Binding have minimal wear and the pages have only minimal creases. Bookseller Inventory # G0789736101I3N10

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.89
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Bill Jelen
Published by Pearson Education
ISBN 10: 0789736101 ISBN 13: 9780789736109
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Yankee Clipper
(Windsor Locks, CT, U.S.A.)
Rating
[?]

Book Description Pearson Education. Paperback. Book Condition: Fair. Bookseller Inventory # G0789736101I5N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.89
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

There are 15 more copies of this book

View all search results for this book