Excel charts with Dynamic Arrays 050: Interactive Fourfolding Taking the torch here; an interactive extension and emulation of the amazing work of Andrés Rojas Moncada who translated to dynamic arrays the works of Hicham Bou… 050: Interactive Fourfolding

Excel charts with Dynamic Arrays 051: Adjustable Chords Ok, this emulation was quite a journey because it’s an interesting visualization for seeing the flows or connections between several entities. A simple example: think of seeing… 051: Adjustable Chords

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 of this graphic is its interactive focus + context (fisheye)… 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. His post on this invaluable chart type led me to… 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 the amazing work of Hicham Bou Habib on making fourfold… 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 or points to facilitate analysts or general audiences in grasping… 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 comparing and judging stuff. Another example below for teaching colleagues… 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 but with good hashtag#Excel skills we can add some spice… 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 a humble replica with mighty Excel, the original graphic was… 052: Essential Sorting