Microsoft Excel | Depict Data Studio

How to Hack Excel — and Add Totals to the Tops of Stacked Column Charts

Jun 20th, 2022 / Data Visualization in Excel

“But you can’t do that in Excel!” Well, maybe you could. In this guest post from Anat Zohar, you’ll learn about three Microsoft Excel hacks: (1) using a scatter plot to create a hex map, (2) adding totals to the tops of stacked column charts, and (3) using symbol fonts.

How to Visualize Margin of Error Data in Excel with “Slider Plots”

Feb 28th, 2022 / Data Visualization in Excel

Andrew Forsman is a Depict Data Studio student and self-described “data viz nerd” who has over 10 years of experience helping organizations plan for, execute, and learn from research and evaluations. Andrew’s sharing examples of slider plots and step-by-step instructions for making them in Excel.

Creating Reports for Grant Deliverables Using Excel Dashboards

Feb 14th, 2022 / Dashboards

Are you tired of text heavy reports to summarize grant findings? Do you want to update the look and feel of your reporting templates? Save time and energy by using static Excel dashboards to design your grant deliverables. Read on to learn more about Josephine Engels’ journey implementing static dashboards in a non-profit context.

Accessibility Quick Wins: Remove Legends and Directly Label

Nov 30th, 2021 / Data Visualization

How do we make our graphs more accessible? There’s a misconception that accessibility takes all day, that’s it’s costly and complicated. Those are all false. Accessibility is woven into all my trainings, but since this is a topic I get asked about a lot, I decided to make a new talk that’s focused just on accessibility for dataviz.

Designing a Prettier and More Effective Dashboard with Excel

Nov 9th, 2021 / Dashboards

Shawna Rohrman, Ph.D., is the Evaluation Manager for the Cuyahoga County Office of Early Childhood and its public-private partnership, Invest in Children. She enrolled in our Dashboard Design course and is sharing how she uses her new skills in real life. Thanks for sharing, Shawna!

Creating a Community through Graphs

Sep 14th, 2021 / Data Visualization

Maddison Staszkiewicz is a Depict Data Studio student and evaluator. She was part of the 2020 Great Graphs: Excel How-To’s cohort and is sharing her experiences with us. She especially loved the community of the course which helped her to learn new techniques, perspectives, gain valuable feedback and much more.

Blog