Advertising
Advertising

Lightweight data exploration in Excel

Lightweight data exploration in Excel

This is such a good trick for spreadsheet user. Juice Analytics have a great trick on plotting graphs within the cell, by using the function REPT() to repeat a single bar character (“|”). They called it a In-cell bar graph:

In Cell Graph

    What are some practical uses of in-cell bar graphs? For starters, they offer a good way to profile a dataset that has hundreds or thousands of rows. Here’s a picture of in-cell bars compared to a standard excel bar graph for a dataset with about 500 rows. It can be a lot easier to scan the results when they’re in-cell.

    Another usage is lightweight dashboards. The report below compares a number of metrics for players using both in-cell bar graphs as well as conditional formatting. The conditional formatting highlights the top 25% of each metric in green and the bottom 25% in red but that is a story for another day.

    Very practical – I am going to use it on my spreadsheets at work!

    Lightweight data exploration in Excel – [Juice Analytics via ideaxidea]

    More by this author

    Leon Ho

    Founder of Lifehack

    Book summary: A Technique for Producing Ideas 10 Ways to Extend Laptop Battery Life Bob Parsons on His 16 Rules for Survival Free note taking templates and techniques Fifty Essential Topics on Economics

    Trending in Lifehack

    1 The Lifehack Show Episode 11: Mindfulness and the Authentic Self 2 What Everyone Is Wrong About Achieving Inbox Zero 3 How to Plan Your Life Goals and Actually Achieve Them in 7 Simple Steps 4 Forget Learning How to Multitask: Boost Productivity 10X More with Focus 5 The Lifehack Show Episode 8: On Personal Success

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on November 3, 2019

    The Lifehack Show Episode 11: Mindfulness and the Authentic Self

    The Lifehack Show Episode 11: Mindfulness and the Authentic Self
    In this episode, we interview Ora Nadrich, a renowned author, Thought Coach and Mindfulness Meditation teacher who taps into her own experiences to help others better understand theirs. She’ll talk about her new book Live True: A Mindfulness Guide to Authenticity and the importance of living an authentic life.
      Ora Nadrich

      Episode 11: Mindfulness and the Authentic Self

      Also available on iTunes and YouTube

      Featured photo credit: Martin Dawson via unsplash.com

      Read Next