enhancing the defaults 007: contextual reference line Reference lines are a powerful graphic feature for comparing values to a benchmark. The line could be the average or median of the items displayed on a chart. … enhancing the defaults 007: contextual reference line

enhancing the defaults 006: bolding the axis The power of contrast in graphic design applied to interactive data visualization with Microsoft hashtag#Excel – Now coloring the bars is relatively easy, but how about the axis… enhancing the defaults 006: bolding the axis

enhancing the defaults 005: red 🔴 dot on axis How powerful can a simple red dot be on the axis of a graph?  Many thanks to Stephen Few for writing about this powerful technique. Let’s… enhancing the defaults 005: red dot on axis

enhancing the defaults 004: labels on axis or at the tip Should data labels be at the tip or end of the bars…or how about on the axis? Which one is better? It depends (as… enhancing the defaults 004: data labels on axis or at the tip

enhancing the defaults 003: left aligned axis Left aligned or right aligned? Which one is better? It depends (as usual in data graphics). Let’s begin how to set it up in with Excel charts:  … enhancing the defaults 003: left aligned axis

enhancing the defaults 002: the helper series The three charts above show or display the same information, but the two on the right look a bit more aesthetically. Why is that? Simply, because the defaults… enhancing the defaults 002: the helper series

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 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