Excel Elbow Grease: How to Fool Excel into Making (Pretty Much) Any Chart You Want

In October 2013, Ann K. Emery presented How to fool Excel into making (pretty much) any chart you want at the American Evaluation Association's annual conference in Washington, D.C. She shared four strategies for communicating data more clearly in Excel: 1) Adjust default settings until charts pass the Squint Test; 2) Create two charts in one; 3) Create invisible sections of charts; and 4) Exploit the stock chart types, for example, by making timelines from stacked bar charts or by making dot plots from scatter plots. /div>

 

Bibliographic Details
Author	Ann K. Emery
Publisher	Innovation Network, Inc.
Publication Date	October 17, 2013
Publication City	Washington, DC, USA
Publication Work
Resource Type	Presentation Slides
Resource Focus	Advocacy Evaluation Analysis and Reflection Action and Improvement
Audience	Evaluators
Region	International or N/A
Keywords	visualizing data slides presenting data presentation microsoft excel making graphs Innovation Network InnoNet excel elbow grease evaluators evaluation eval13 DVR TIG dataviz data visualization charts chart best practices Ann Emery
Submitted to Point K	May 8, 2014 - 11:08am