Importantly-and what I think is particularly great about her redesign-is the “30%” and “50%” labels on the right of each column. She also adds labels to the left of the left-hand column. What Cole does is to highlight just the three segments that are of particular interest. The default chart with data labels on each slide looks something like this: The basic data include two values for seven different Segments. It works the same way on the Excel 2010 Windows version, but will be a bit different on the 2013 or 2016 versions of Excel.)
(Note: I’m using the Mac version of Excel 2011 for this tutorial. 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.
0 kommentar(er)
