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 the traffic flow of people between the airports of major cities in a circular format. On the video below, the small table of data (on the left) is being plotted on the chord diagram (on the right side).

track id: Crackazat – Everybody Talks About It (Original Mix) played dj Marky

Now, this is just a humble translation to dynamic arrays from the amazing and mind-blowing work of The Frankens Team (roberto mensa being one of them). Their Excel charts has been influential to my work. And I’m very happy to see Roberto back in action with more superb graphics made in Excel.

You can find the original work here: https://lnkd.in/exAvQrqg

My contribution: translating the original work to dynamic arrays and adding the possibility to add or remove entities on the chord diagram. Huge thanks to Andrés Rojas Moncada, Bhavya Gupta and John Jairo Vergara Domínguez for their amazing help with some array formulas that were essential for the back end of this advanced visualization on spreadsheet.

Bonus! > 5 real Inspirational Chord Diagrams!
https://www.streetlightdata.com/chord-diagrams-visualization-data/

key visual features of chord diagrams:

• they allow you to quickly comprehend the magnitude of different flows and compare the flow between several entities at once.
• the thickness of the chords is intuitive for comparing the scale and volume of the flows between entities.
• a chord diagram simplifies the interconnected relationships between entities and allows seeing the full picture.