guerrilla data analyst.
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… Read More »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… Read More »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 %… Read More »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… Read More »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:… Read More »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… Read More »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… Read More »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)… Read More »008 Excel Charts with Dynamic Arrays: Markers with Images
#Excel ´s new # Dynamics Arrays Spill Ranges # for adding a bit of interactivity on a connected scatter plot inspired from Jorge Camoes amazing… Read More »007 Excel Charts with Dynamic Arrays: Connected scatter plot
A bit of Sabermetrics with #Excel ´s new # Dynamic Arrays formulas # for switching your X or Y variables on a scatter plot along… Read More »006 Excel Charts with Dynamic Arrays: Switching X or Y axis