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 by having control over how the chart is dynamically presented. With Form Controls or PivotTable slicers, we can determine what to display on the visualization and progressively reveal each of its data points as we advance through the presentation. With Excel’s new calculation engine, including spilled ranges and the new functions of Dynamic Arrays, implementation becomes much easier.

At SWD = storytelling with data site lead by Cole Nussbaumer Knaflic, there are countless opportunities for you to learn about data visualization. This is my first proposal for a interesting exercise on the discussion of data tables in a chart. As always you can download the file here 👉 https://lnkd.in/dN49MPM​​ | chart name: “016: My first SWD exercise”, as for my submission to the exercise you can check it out here: https://lnkd.in/d5M7H6k Pro-tip: check out the submission of others, there are very good and join this awesome community and practice, it´s free. 😁

track id: Per Qx – Topic feat. Jocelyn Brown – It Ain’t Over (David Penn Extended Edit) played by living legend: Carl Cox.

Distributing the credit backwards: the work above was inspired from this excellent exercise: “data table: use it or lose it?” from storytelling with data link: https://community.storytellingwithdata.com/exercises/data-table-use-it-or-lose-it  << This website is a university on its own on how to present information. Highly recommended.

And finally, I don’t make data graphics for the masses to watch to. I make data graphics for the small majority that want to see. Quote re-adapted from DJ Moodymann: “I don’t make music for the masses to dance to. I make music for the small majority that listens.”