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
enhancing the defaults 005: red 🔴 dot on axis How powerful can a simple red dot be on the axis of a graph?  Many thanks to Stephen Few for writing about this powerful technique. Let’s… enhancing the defaults 005: red dot on axis
enhancing the defaults 004: labels on axis or at the tip Should data labels be at the tip or end of the bars…or how about on the axis? Which one is better? It depends (as… enhancing the defaults 004: data labels on axis or at the tip
enhancing the defaults 003: left aligned axis Left aligned or right aligned? Which one is better? It depends (as usual in data graphics). Let’s begin how to set it up in with Excel charts: … enhancing the defaults 003: left aligned axis
enhancing the defaults 002: the helper series The three charts above show or display the same information, but the two on the right look a bit more aesthetically. Why is that? Simply, because the defaults… enhancing the defaults 002: the helper series