Transforming Knowledge into Change

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
Resource Focus
Audience
Region
Keywords
Submitted to Point K May 8, 2014 - 10:08am

Point K Pick


Download

web icon Web Link
Login to review this resource