Excel charts with Dynamic Arrays 030: Dynamic Table Lens Table Lens for displaying potential correlations, patterns, or outliers between several quantitative variables simultaneously. The strength… Read More »030: Dynamic Table Lens

Excel charts with Dynamic Arrays 031: Scatterplot Matrix This is the translation of an amazing blogpost and outstanding work from Hicham Bou Habib CCIM, MRICS.… Read More »031: Scatterplot Matrix

Excel charts with Dynamic Arrays 049: Random Wafflefolds Consider the following below a variant using a scatterplot for plotting a randomized fourfold display. Inspired from… Read More »049: Random Wafflefolds

Excel charts with Dynamic Arrays 047: Switching Encoding The term encoding in data visualization can refer to “packaging” quantitative information into visual elements like lines… Read More »047: Switching Encoding

Excel charts with Dynamic Arrays 048: Swapping Contexts Numbers or metrics shine when they are put into context. I believe we are “comparative creatures”, always… Read More »048: Swapping Contexts

Excel charts with Dynamic Arrays 016: My first SWD exercise Static charts: 😴 | Dynamic interactive charts: 😎 Static charts are great for data storytelling… Read More »016: My first SWD exercise

Excel charts with Dynamic Arrays 052: Essential Sorting Inspired by the following graphic made by The New York Times: Source: https://www.nytimes.com/2020/09/24/learning/whats-going-on-in-this-graph-essential-workers.html I decided to make… Read More »052: Essential Sorting

enhancing the defaults 007: contextual reference line Reference lines are a powerful graphic feature for comparing values to a benchmark. The line could be the… Read More »enhancing the defaults 007: contextual reference line

enhancing the defaults 006: bolding the axis The power of contrast in graphic design applied to interactive data visualization with Microsoft hashtag#Excel – Now coloring… Read More »enhancing the defaults 006: bolding the axis