Tag archive for Data Bars

Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal

Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal

I met Mia Schmid in 2017 when she enrolled in one of my Dashboard Design workshops. Later, she reached out and shared her own before/after makeover based on what she learned in the training. Her makeover was so dramatic that I wanted to share it…

Continue reading →

How to Visualize Workshop Evaluation Results

How to Visualize Workshop Evaluation Results

I give dozens of workshops, webinars, and conference keynotes each year. Which means I receive dozens of evaluation surveys each year. After my sessions, the clients who sponsored the workshop ask their participants to rate my session. Sometimes the satisfaction surveys are electronic. Other times, the satisfaction…

Continue reading →

How to Quickly Visualize Patterns with Excel’s Data Bars

How to Quickly Visualize Patterns with Excel’s Data Bars

Data bars are miniature within-cell bar charts. I primarily use them to quickly explore patterns in my dataset. Sometimes I decide to make an actual bar chart of the data later on. Other times, I’m simply using these tiny charts to help my brain spot…

Continue reading →

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…

Continue reading →