#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. As always, you can download the file here… 018 Excel Charts with Dynamic Arrays: Rapid Box plots
#Excel ´s # Dynamic Arrays #” for creating a unit plot, the waffle plot or the “Unit Star” plot, maybe? I don´t know what name to put it… 😝😂 in this example, the =SEQUENCE() function is… 017 Excel Charts with Dynamic Arrays: Units, Stars and Waffle plot
Highlighting the axis items of a chart ? Yes, it´s possible with or without dynamic arrays. In this case, I used dynamic arrays as building the formulas and referencing them to the chart is rapid… 015 Excel Charts with Dynamic Arrays: Highlighting Axis Item
Post 5 of 5: #Excel ‘s # 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” thank you… 014 Excel Charts with Dynamic Arrays: Anscombe´s Quartet
Post 4 of 5: Small Multiples, Step Lines & #Excel´s # Dynamic Arrays # for plotting the continuous decrease in world regions of the share % population living in extreme poverty, according to the The World Bank .… 013 Excel Charts with Dynamic Arrays: Small Stepped Multiples
Post 3 of 5: Cycle plots with #Excel ‘s # Dynamic Arrays #. Cycle plots are particularly useful because it can show a great deal of information in a small space, prompting to ask a lot of… 012 Excel Charts with Dynamic Arrays: Cycle Plots
Post 2 of 5: “Dynamic Horizons” with #Excel ´s Dynamic Arrays 😅 here is a simple model where you can analyze data by time intervals: last 7 days, last month, last 3 years, 10 years… 011 Excel Charts with Dynamic Arrays: Dynamic Horizons
Post 1 of 5: this week it´s going to be “Charting with Dynamic Arrays “, where I will sharing 5 charts with the mission to promote the #Excel´s new functions: # Dynamic Arrays # these… 010 Excel Charts with Dynamic Arrays: Index Chart
Happy St. Patrick’s Day! and another #Excel chart with dynamic arrays, this time on spotlight is the SEQUENCE function, i believe it can assist on storytelling your data by making your charts to have “motion”… 009 Excel Charts with Dynamic Arrays: Sequencing Growth
Just discovered a couple of weeks ago that in Excel you can add a custom shape to your marker (on line charts or scatter plots) or you can also add an image. Below I am… 008 Excel Charts with Dynamic Arrays: Markers with Images