guerrilla data analyst.
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
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… Read More »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… Read More »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 –… Read More »029 Excel Charts with Dynamic Arrays: Dynamic Table Lens