Meaningful Graphs: Converting Data Into Informative Excel Charts

James M. Smith

Book cover for Meaningful Graphs: Converting Data Into Informative Excel Charts
Book cover for Meaningful Graphs: Converting Data Into Informative Excel Charts

Meaningful Graphs: Converting Data Into Informative Excel Charts

Meaningful Graphs: Converting Data Into Informative Excel Charts

James M. Smith

  • Become a member to save 30% on all book orders, plus a variety of great perks. Simply add any book to cart and you’ll see an option to become a member
  • 100% of this book's profits go to our community of authors.
Get 50% off your first order, and then 30% off everything
Member Book Price
$33.27$16.64
Monthly Membership
First month free, renews at $5.00
$0.00

Already a member? Log In To Access Member Price

  • Allstora Membership will renew at $5/month, cancel any time. Learn More

Description

Meaningful Graphs is a concise and practical go-to guide for creating charts in Excel (R) that clearly and accurately tell the story in your data. It incorporates (a) explanations of the graph design principles of the experts (Tufte, Few, Robbins, Zelazny, and others), (b) the software steps necessary to incorporate these principles into Excel (R) charts, and (c) chart-related discussions of quality improvement (including Pareto charts), statistics (including run charts and correlations), and the use of graphs in PowerPoint (R) presentations (including chart animation). Also included are numerous "Tips" and "In Practice" examples drawn from over 35 years of working with data in healthcare settings. Coverage begins with highlighting the importance of knowing the story in your data and general principles of chart design (e.g., chartjunk, the use of color, consideration of three dimensional charts) and then proceeds to examine and create the five major chart types (column, bar, line, pie, scatter). This is followed by considerations of the pros and cons of each of the six less frequently employed chart types. There are over 120 graphs in full color plus tables and illustrations. Discussions of the most useful chart types include examples with accompanying data to facilitate practice. While illustrations are especially tailored for healthcare professionals (physicians, nurses, patient safety, quality improvement staff, executives, and managers) both in their work setting and in their academic preparation, the principles of graph design and the Excel (R) techniques required to incorporate these principles apply equally well in other settings. The latter include other industries and academic programs, including those leading to degrees in business administration (MBA), public health (MPH), and public administration (MPA). If you follow the advice in this book, the graphs you create for reports, presentations, posters, or publications will be more informative and more easily understood.

Publishing Information

Publisher: James M. Smith
Pub date: 2014-06-01
Length: 228 pages
View full details

The Allstora Membership

Membership Perks:

  • Save 30% on all online store purchases
  • Exclusive access to author's content
  • You pay less, but authors still earn double

Membership Terms:

First Month: $0.00
Monthly price: $5.00
  • To access membership discount simply log in and add to cart, discount applied automatically.
  • One month free trial, cancel anytime. Membership renews on the 15th of each month.