'Dressed-Up' Dot Plots in Excel

Picture of Dot-Plot Chart

Dot plots are one of Ama’s favorite types of visualizations. Valued for their ability to support quick comparisons across groups or over time, they are a powerful tool for data storytelling. However, traditional dot plots often include excessive white space, which can make them difficult to interpret. In this personal project, Ama challenged herself to rethink that design limitation. The resulting graph was created in Excel by overlaying a bar chart on a scatter plot. The data was sourced from the Pennsylvania Department of Education, Pennsylvania System of School Assessment (PSSA) Results website.