enhancing the defaults 008: charts à la The Economist to all Excel colleagues out there, have you noticed this new feature: high contrast only toggle? (it appears in the video below when I right… 010 : charts à la The Economist
Excel charts with Dynamic Arrays 054: Beeswarm Histodots A releasable version for everybody on three more ways of showing distributions with: Wilkinson Histodots, Beeswarm plot or Kernel Density Estimation on job salaries across position. But… 054: Beeswarm Histodots
Excel charts with Dynamic Arrays 055: US election map What you see above is just a humble replica from an interesting visualization of the US elections of 2020 by French newspaper Le Monde. And this… 055: US election map
Excel charts with Dynamic Arrays 003: Dynamic Sorted chart Let me tell you something: Learn the new functions of #Excel, the future ahead is bright with these # Dynamic Arrays Formulas # . Below it´s… 003: Dynamic sorted chart
Excel charts with Dynamic Arrays 050: Sorting & Filtering charts Below an example where you can use them to SORT or FILTER your charts in #Excel with slicers and form controls (no VBA :P) Let’s… 002: Sorting & Filtering charts
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