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
Step Charts with Dynamic Arrays in #Excel. If someone has a simpler dynamic array formula to get the “Step” effect on the chart I would welcome it, my “backbone” formula is a bit complex and… 005 Excel Charts with Dynamic Arrays: Line to Step chart
Dynamic #Excel Charts with # Dynamic Arrays formulas # Cristiano Galvão I decided to get the “arrow chart” or … “the Spartan chart”. A bit more dynamic! it reminded of our good time in Sao… 004 Excel Charts with Dynamic Arrays: Arrow Chart
Reference bands in data graphics are especially important because they can serve as – guidance – for your audience as well as tools for – focus – in specific data points on your visualizations or…… 029 Excel Charts with Dynamic Arrays: Dynamic Table Lens