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
#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, which you… 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 with filtering the data set and dynamic titles based on… 006 Excel Charts with Dynamic Arrays: Switching X or Y axis