


I try to avoid adding text boxes or drawing lines when building charts in Excel because I find they rarely end up exactly where I want them, it’s harder to move them over to PowerPoint, and, most importantly, I will have to manually move things around when I update the data.

If you follow the Excel tutorials on this blog, you’ll know that I always try to use data to add labels, markers, and other chart elements. So, I thought I might take an opportunity to show you how I would make this graph in Excel. This attention to aesthetics shows a general respect for your work and your audience.” I couldn’t agree more. It looks something like this:Ĭole writes, “Being smart with color, aligning objects, and leveraging white space brings a sense of visual organization to your design. In Chapter 5 of Cole Nussbaumer’s new book, Storytelling with Data, she shows a revised version of a stacked column chart that highlights three segments with labels off to the left and two summary numbers to the right.
