#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