James M. Smith

Meaningful Graphs: Converting Data into Informative Excel Charts James M. Smith 1st edition

Meaningful Graphs is a concise and practical go-to guide for creating charts in Excel ® that clearly and accurately tell the story in your data. It incorporates (a) the graph design principles of the experts, (b) the software steps necessary to incorporate these principles into Excel ® 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 ® presentations (including chart animation). Examples are taken from healthcare with over 120 graphs in full color, many with tables of data to facilitate practice.

Reading this book you'll learn:

• how to select the correct chart type for your data and how to format it to tell your story more effectively
• the nature of "chartjunk" and why the design of some charts requires mental gymnastics to interpret
• why looks can be deceiving (3-D charts)
• the appropriate use of color in charts
• why truncating the value axis of several types of charts is a fatal flaw
• how to determine whether a statistically significant change has occurred merely by calculating the mean or median and plotting the data
• the type of chart that one chart design expert refers to as a mortal sin
• why chart design experts disparage the use of pie charts and what they recommend in their place
• which of the six less frequently used chart types (area, stock, surface, doughnut, bubble, and radar) may have some value in healthcare applications
• how letting the data talk in their own terms often leads to problem solutions

If you follow the advice in this book, the graphs you create for reports, presentations, posters, or publications will be more informative and more readily understood.