Preface |
|
xii | |
Acknowledgments |
|
xvii | |
About the Authors |
|
xviii | |
Section I: Displaying Data |
|
1 | (118) |
|
Chapter 1 Choosing Data Displays |
|
|
3 | (10) |
|
Information and Audience Considerations |
|
|
3 | (1) |
|
|
3 | (1) |
|
Who Is the Audience for Your Data? |
|
|
3 | (1) |
|
What Does the Audience Know? |
|
|
4 | (1) |
|
What Will the Audience Do With the Information? |
|
|
4 | (1) |
|
Are You Preparing a Report or Presentation? |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
5 | (1) |
|
Forms of Data Visualization Covered in This Text |
|
|
5 | (6) |
|
|
6 | (4) |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
Which Form of Data Visualization to Use |
|
|
11 | (1) |
|
|
11 | (2) |
|
Chapter 2 Bar and Column Charts |
|
|
13 | (30) |
|
Data Appropriate for Bar and Column Charts |
|
|
14 | (6) |
|
|
20 | (2) |
|
100% Stacked Column Charts |
|
|
22 | (5) |
|
Best Practices for Creating Column and Bar Charts |
|
|
27 | (12) |
|
|
28 | (2) |
|
|
30 | (2) |
|
|
32 | (1) |
|
|
32 | (5) |
|
|
37 | (2) |
|
Choosing Between Bar and Column Charts |
|
|
39 | (1) |
|
|
40 | (1) |
|
|
41 | (2) |
|
Chapter 3 Line and Area Charts |
|
|
43 | (18) |
|
Single-Series Line Charts |
|
|
44 | (3) |
|
|
47 | (4) |
|
|
50 | (1) |
|
|
51 | (3) |
|
|
54 | (2) |
|
|
56 | (3) |
|
|
59 | (1) |
|
|
59 | (2) |
|
|
61 | (16) |
|
The Trouble With Pie Charts |
|
|
62 | (1) |
|
|
63 | (3) |
|
Best Practices for Creating Pie Charts |
|
|
66 | (6) |
|
Alternatives to Pie Charts |
|
|
72 | (2) |
|
|
74 | (3) |
|
Chapter 5 Chart Formatting |
|
|
77 | (42) |
|
Remove Unnecessary and Redundant Information |
|
|
78 | (3) |
|
|
81 | (3) |
|
|
84 | (5) |
|
|
85 | (4) |
|
|
89 | (9) |
|
|
90 | (2) |
|
Axes and Individual Data Labels |
|
|
92 | (2) |
|
|
94 | (3) |
|
|
97 | (1) |
|
|
98 | (1) |
|
Labeling Individual Data Values |
|
|
99 | (1) |
|
Labeling the Y-Axis on a Bar Chart |
|
|
100 | (2) |
|
Formatting Numbers on Data Labels and Axes |
|
|
102 | (3) |
|
Use the Thousands Separator on Data Labels and Axes |
|
|
103 | (1) |
|
|
103 | (1) |
|
Only Use as Many Decimals as Necessary |
|
|
104 | (1) |
|
|
105 | (4) |
|
|
109 | (2) |
|
|
110 | (1) |
|
|
110 | (1) |
|
|
111 | (2) |
|
Color of the Bars, Lines, and Slices of Pie |
|
|
111 | (2) |
|
|
113 | (2) |
|
|
115 | (2) |
|
|
117 | (2) |
Section II: Preparing Data For Charting |
|
119 | (88) |
|
Chapter 6 Preparing Data for Charting |
|
|
121 | (32) |
|
|
121 | (1) |
|
|
122 | (1) |
|
|
123 | (4) |
|
|
123 | (1) |
|
|
124 | (3) |
|
|
127 | (19) |
|
Creating a Simple Summary Table |
|
|
127 | (1) |
|
Creating a Complex Summary Table |
|
|
128 | (4) |
|
Computing Summary Statistics |
|
|
132 | (14) |
|
Creating a Dynamic Summary Table |
|
|
146 | (2) |
|
|
148 | (3) |
|
|
151 | (2) |
|
Chapter 7 Pivot Tables and Pivot Charts |
|
|
153 | (24) |
|
Introduction to Pivot Tables |
|
|
153 | (2) |
|
Organizing Data for Pivot Tables |
|
|
155 | (7) |
|
|
159 | (3) |
|
Modifying and Exploring a Pivot Table |
|
|
162 | (1) |
|
Transposing Rows and Columns |
|
|
162 | (1) |
|
|
163 | (2) |
|
Changing Summary Data Values |
|
|
165 | (1) |
|
|
166 | (1) |
|
|
167 | (3) |
|
Refreshing Pivot Table Data |
|
|
170 | (1) |
|
|
170 | (2) |
|
|
172 | (4) |
|
|
176 | (1) |
|
Chapter 8 Tables: When Charts Aren't Enough |
|
|
177 | (30) |
|
|
177 | (7) |
|
Easy Sorting and Filtering |
|
|
179 | (2) |
|
|
181 | (1) |
|
Perpetually Visible Headers |
|
|
182 | (1) |
|
|
183 | (1) |
|
Table Formatting Best Practices |
|
|
184 | (15) |
|
Creating an Excel Table Using Format as Table |
|
|
186 | (2) |
|
Borders, Rules, and Grids |
|
|
188 | (1) |
|
Row and Column Formatting |
|
|
189 | (4) |
|
|
193 | (3) |
|
|
196 | (2) |
|
|
198 | (1) |
|
|
199 | (1) |
|
|
199 | (4) |
|
|
203 | (1) |
|
|
204 | (3) |
Section III: Presenting Data |
|
207 | (108) |
|
Chapter 9 Creating Reports |
|
|
209 | (46) |
|
|
209 | (4) |
|
|
210 | (1) |
|
|
210 | (3) |
|
Moving Charts From Excel to Word |
|
|
213 | (4) |
|
Moving Tables From Excel to Word |
|
|
217 | (3) |
|
|
220 | (3) |
|
|
220 | (2) |
|
|
222 | (1) |
|
|
223 | (16) |
|
Creating Professional Reports in PowerPoint |
|
|
223 | (16) |
|
|
239 | (1) |
|
|
240 | (5) |
|
Creating Posters and Infographics With PowerPoint |
|
|
242 | (1) |
|
Guidelines for Creating Posters |
|
|
243 | (2) |
|
|
245 | (8) |
|
Designing a Dashboard in Excel |
|
|
246 | (7) |
|
|
253 | (2) |
|
Chapter 10 Creating Presentations |
|
|
255 | (34) |
|
Perspectives on Presentations |
|
|
256 | (4) |
|
|
256 | (1) |
|
|
257 | (1) |
|
|
258 | (1) |
|
|
258 | (1) |
|
|
259 | (1) |
|
|
259 | (1) |
|
Three Presentation Elements |
|
|
260 | (1) |
|
Designing Audience Slides |
|
|
260 | (22) |
|
|
261 | (1) |
|
Minimize Text, Maximize Images |
|
|
262 | (5) |
|
|
267 | (2) |
|
|
269 | (2) |
|
Add Images on Nondata Slides |
|
|
271 | (3) |
|
|
274 | (1) |
|
Use Animations and Transitions to Maintain Attention |
|
|
275 | (7) |
|
|
282 | (2) |
|
|
284 | (3) |
|
|
287 | (2) |
|
Chapter 11 Delivering Presentations |
|
|
289 | (18) |
|
Preliminary Considerations |
|
|
289 | (1) |
|
|
290 | (4) |
|
|
290 | (1) |
|
|
291 | (2) |
|
|
293 | (1) |
|
Addressing Audience Questions |
|
|
294 | (1) |
|
Working With the Physical Space |
|
|
294 | (2) |
|
Speaking Into a Microphone |
|
|
296 | (1) |
|
|
297 | (2) |
|
Going Pro With Presenter View |
|
|
299 | (3) |
|
Delivering Presentations Remotely |
|
|
302 | (4) |
|
|
304 | (1) |
|
|
304 | (1) |
|
|
305 | (1) |
|
Prepare a Webinar Version of PowerPoint Slides |
|
|
305 | (1) |
|
|
305 | (1) |
|
Delivering the Presentation |
|
|
305 | (1) |
|
|
306 | (1) |
|
Chapter 12 Concluding Comments |
|
|
307 | (8) |
|
Collecting or Downloading Data |
|
|
308 | (1) |
|
Cleaning, Organizing, and Analyzing Data |
|
|
308 | (1) |
|
Creating Charts and Tables |
|
|
308 | (1) |
|
|
309 | (1) |
|
Designing Presentations and Creating Handouts |
|
|
309 | (1) |
|
Rehearsing and Delivering Presentations |
|
|
309 | (1) |
|
Mastering Data Visualization Skills |
|
|
310 | (2) |
|
Suggestions for Further Study |
|
|
312 | (3) |
|
The Visual Display of Quantitative Information |
|
|
312 | (1) |
|
|
313 | (1) |
|
|
313 | (1) |
|
Visual Thinking for Design |
|
|
313 | (1) |
|
Microsoft Excel 2013 Bible |
|
|
313 | (1) |
|
Pivot Table Data Crunching: Microsoft Excel 2013 (MrExcel Library) |
|
|
314 | (1) |
|
Slideology: The Art and Science of Creating Great Presentations |
|
|
314 | (1) |
|
|
314 | (1) |
Appendix A: Excel Basics |
|
315 | (14) |
Appendix B: Configuring Microsoft Word for APA-Style Reports |
|
329 | (5) |
Index |
|
334 | |