Clearly and Simply

Tag: trellis charts in excel

  • A practical Example for Dynamic Storyboards

    A more practical use case for Dynamic Storyboards in Excel: support the Animation of 2-dimensional data by showing the years before and after the current year on a Storyboard

    717 words, ~3.5 minutes read

    The previous post Dynamic Storyboards in Excel showed how to create small multiples (or panel or trellis charts) for 2-dimensional data in a sequence and let the user decide dynamically, how many small multiples shall be displayed. To describe the technique, the article used a kind of funny, but pointless data set: a part of an episode of the Italian cartoon series La Linea.

    Well, creating a dynamically sized comic strip in Excel is a funny little example. But what’s the point here?

    Gapminder Replica with Storyboard IntroHere’s the point: a Dynamic Storyboard may well be worth considering for a more serious dashboard, too. For instance, a Dynamic Storyboard may support a chart which displays the data for the periods one by one in an animation. The Storyboard can be very useful by showing the data in the context of a user-defined number of years before and after the current period. This can help to better understand the development of the data over time or to discover patterns.

    Today’s post will show how a Dynamic Storyboard may support an animated chart using the example of the Gapminder Replica in Microsoft Excel, published here back in 2014. As usual, the article comes with the workbook for free download.

    (more…)

  • Dynamic Storyboards in Excel

    How to create a Dynamic Storyboard of Small Charts (similar to Small Multiples, Panel or Trellis charts) in Microsoft Excel

    812 words, ~4 minutes read

    The article Motion Chart Excel Template used a small sequence of an episode of the Italian cartoon series La Linea to demonstrate how a chart can be animated in Microsoft Excel. I also used the same data in one of my entries to a Tableau data viz contest: Tableau’s Viz as Art Contest – My Entries.

    Since it is a cartoon series, it is kind of obvious to also think about visualizing the data in a comic strip (or what I will call storyboard hereafter).

    Today’s challenge is to make the size of the storyboard dynamic, i.e. let the user decide with one mouse click, how many images shall be displayed.

    Dynamic Storyboards in Excel Intro

    This article describes how to do this in Excel and – as usual – comes with the example workbook for free download.

    (more…)