On the left is a replica made in Excel inspired from the amazing #Tableau viz of Klaus Schulte on "Amazons Profitable Growth." Link his viz: https://lnkd.in/dPFz3EZ
On the right, is an example where you can use them to SORT or FILTER your charts in Excel with slicers and form controls (no VBA)
On the left, is an example of dynamic sorting the categorical axis per week by the sales of each executive and its cummulative progress % to their weekly cuota.
On the right, an "arrow chart" with dynamic arrays formulas.
On the left, a line or step chart with the possibility to switch it between the two: line or step with dynamic arrays in Excel.
On the right, switching your X or Y variables on a scatter plot along with filtering the data and dynamic titles based on the variables you choose.
Excel´s new # Dynamics Arrays Spill Ranges # for adding a bit of interactivity on a connected scatter plot inspired from Jorge Camoes amazing visualization: US Military Expenditure vs. Number of Troops.
In #Excel you can add a custom shape to your marker (on line charts or scatter plots) or you can also add an image. On the left, I replaced the dot marker with the photo of the respective US President according to his era or period.
Dedicated to St. Patrick’s Day! on spotlight is the SEQUENCE function, where it could assist on storytelling your data by making your charts to have "motion". As they say, "motion creates emotion..."
This is a 3rd variation of Jorge Camões' chart of "US # of Troops vs. Military spending" using the Index chart. This type of chart helps to compare values which are vastly apart and also, understand variation with respect to a bench mark: this case year 1989. Special thanks to Robert Mundigl for the discussion and proposal to make this chart possible.
With Excel´s Dynamic Arrays, you can analyze data by time intervals: last 7 days, last month, last 3 years, 10 years maybe? and/or maybe see the index variation % (switching the charts), also you can add last 7-day-moving average or 5-day centered moving average. All possible with a bit of dynamic arrays and slicers (including time slicers assisted with #DAX ).
Cycle plots are particularly useful because it can show a great deal of information in a small space, prompting to ask a lot of meaningful questions in search of understanding the impact of month of year and the behavior of seasonal time series or the cyclical patterns over time in #data. You are seeing up yo 12 years of data without (and I hope…) information overload.
Small Multiples, Step Lines & #Excel´s #Dynamic Arrays # for plotting the continuous decrease in all regions of the share % population living in extreme poverty, according to the World Bank.
# Dynamic Arrays # meets Anscombe´s Quartet, The Datasaurus Dozen and DataTrump from Alberto Cairo. In data visualization, very often you come across this mantra: “always visualize your data” by Alberto Cairo. The summary statistics of all these visuals remain the same! (except “DataTrump”) It´s impressive!
A filterable dot plot for comparing the different length in years of several products' life cyles and highlighting the axis items when the item or product began and when it ended being offered to the market. Special thanks to Mike Girvin from ExcelisFun YouTube channel !
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.
The unit plot, the waffle plot or "Star Units" plot with the awesome "Dynamic Arrays " functions. In this example, =SEQUENCE() is the All-Star!
Excel´s native box plots are not the best, but maybe combined with # Dynamic Arrays #, they can serve to rapidly explore the distributions of your data.
With # Dynamic Arrays #, it´s possible to adjust dynamically the bins of a histogram. In this example, they re-adjust them really fast with more than 30,000 records on a spreadsheet.
With scatter plots in Excel combined with # Dynamic Arrays #, it´s possible to build an interactive "UpSet plot". On the left is a replica made in Excel inspired from the amazing #Tableau viz of Chris Love on this type of graph. You can find Chris´visualization on this url link 👉 https://lnkd.in/d4BX63h please note: it might take you a bit of time to understand this chart, but don´t give up (please), in the end it´s highly rewarding due to it´s informative level in a small space, voilá!
With the MOD and SEQUENCE functions it´s possible to rotate a pie chart. 😁 Pie charts, when done properly can offer the possibility to be the "Gateway chart", meaning it can be used as a inter point, allowing you to communicates a simple fact that you can use as a reference point, but then connect it to a more detailed data. Thank you Jorge Camões for teaching me this.
Combining # dynamic arrays # with the Pareto Principle 80/20, but with a different touch: a "vertical Pareto" for improved readability on the category labels. In data visualization aiming for legibility is key. Many thanks to Jon Peltier (The Da Vinci of Excel Charts) for blogging 11 years ago about building vertical Paretos, link to his post here 👉 https://peltiertech.com/pareto-charts/
The SORTBY function makes it possible to sort your charts on ascending or descending order either on a metric or field value. Here is a simple model where you can SORT the dot plots either by the current year, prior year, or the variance between the two, along with also analyzing and comparing the share % of online sales between the two years by US counties.
Similar to dot plots which aim to emphasize the variation between two values, here you have what´s called "floating delta bars". The setup is identical to graph "023: Sorting Dot Plots" but on this example, you can now switch the variation calculation on the concatenated category labels between absolute or relative % and also, with one click showing or hiding all the labels at once, along with showing a red dot, serving as an alert 🚨 for the values that decreased compared to year 2019.
"Dynamic Arrays are like rubber bands, and the coolest thing is that you can control it´s elasticity." They can serve you very well when measuring the distribution of your data. In this example, all charts: histogram, barcode plot, strip plot or jitter plot and the box plot are pulling the data dynamically and interactively with pivot table slicers, and it´s all possible because of this new and awesome functionality called: "spill range" of # Dynamic Arrays #.
a lot of potential with Excel´s new functions: Dynamic Arrays for Excel charting ... get out of social media and start learning them ! #now 👽👾🤖👻💀 || Image taken from Second edition of The Visual Display of Quantitative Information by Edward Tufte.