Sorting and Filtering Your Spreadsheets

Sorting and Filtering Your Spreadsheets

Have a list of words that need some alphabetizing? Have a list of numbers that you want to arrange from least to greatest or greatest to least? Rather than painstakingly rearranging your rows by hand, let Excel’s Sorting and Filtering features do the heavy lifting…

Continue reading →

One Dataset, Five Line Charts

One Dataset, Five Line Charts

I recently partnered with a group of public health researchers. We were brainstorming different ways to display the number of new HIV infections in each subgroup. The organization wanted to compare HIV infections among men who have sex with men (MSM), African Americans, Hispanics/Latinos, and injection…

Continue reading →

When Pie Charts Are Okay (Seriously)

When Pie Charts Are Okay (Seriously)

Within the past year, I’ve led 60+ in-person and virtual workshops for 2,800+ participants. Most of these trainings have focused on data visualization best practices and how-to’s; other topics have included dashboard automation, research methods, and data analysis. I can always tell when someone has…

Continue reading →

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Have a spreadsheet full of employee contact information? Demographic data for people in your community? A list of classmates attending that upcoming reunion? Most of our spreadsheets contain peoples’ names at some point in the project lifecycle. Here are a few shortcuts for dealing with text…

Continue reading →

Axis Labels, Data Labels, or Both? Four Line Graph Styles to Consider

Axis Labels, Data Labels, or Both? Four Line Graph Styles to Consider

Data visualization is more about strategic thinking than about following steadfast rules. Take a simple line graph, for example. How will you label your line graph? With vertical axis labels and light gray grid lines? With labels directly above or on top of the data…

Continue reading →

Page 4 of 33 ← First ... 2 3 4 5 6 ... Last →