enhancing the defaults 001: the cross markers The two charts above show or display the same information, but the one on the right looks a bit more aesthetically. Why is that? Simply, because the defaults… enhancing the defaults 001: the cross markers
Excel charts with Dynamic Arrays 046: Plotting Dice Rolls Inspired by the following video below, made by YouTube channel: 3blue1brown On minute 12 the image below appeared: Let’s emulate it with Excel: For… 046: Plotting Dice Rolls
Excel charts with Dynamic Arrays 045: Rotating Polygons Inspired by the following video below, made by Andrés Rojas Moncada from the YouTube channel Excel Hecho Facíl: I proceeded with emulating his work and adding… 045: Rotating Polygons
So, the inspiration for this blogpost came after coming across this interesting graph made in R: What caught my attention were two things: This was a dumbbell plot displaying time series vertically. It’s a bit… 041: Referenced Dumbbells
#Excel ´s native box plots are not the best, but maybe combined with # Dynamic Arrays #, they can serve to rapidly explore the distributions of your data. As always, you can download the file here… 018 Excel Charts with Dynamic Arrays: Rapid Box plots
#Excel ´s # Dynamic Arrays #” for creating a unit plot, the waffle plot or the “Unit Star” plot, maybe? I don´t know what name to put it… 😝😂 in this example, the =SEQUENCE() function is… 017 Excel Charts with Dynamic Arrays: Units, Stars and Waffle plot
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