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

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 average or median of the items displayed on a chart. … 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 the bars is relatively easy, but how about the axis… enhancing the defaults 006: bolding the axis