Excel Elbow Grease: How to Fool Excel into Making (Pretty Much) Any Chart You Want Conference presentation
Conference presentation at the American Evaluation Association annual conference
Tired of using the same old pie charts, bar charts, and line charts in Excel to communicate your evaluation results? Don’t have expensive data visualization software? Can’t afford to hire a graphic designer to transform your default Excel charts into polished masterpieces?
In this 45-minute demonstration, I taught attendees how to leverage ‘Excel elbow grease’ to communicate data effectively in Microsoft Excel, including:
- Adjusting default settings until your chart passes the Squint Test;
- Building two (or more) charts into one;
- Creating white floating bars so that certain chart features appear invisible; and
- Exploiting the stock chart options (e.g., using a scatter plot to create a dot plot, or using a stacked bar chart to create a timeline).