No need to add another series and edit the series names one at a time. To sum up: (1) build a bar chart (2) add an error bar (3) format the error bar with a circle at the end. You can then add a title, and format the gridlines, x-axis labels, and y-axis labels as you see fit. You can also change the color in the Color menu in the same menu.
You can then choose the circle size in the Begin Arrow size menu. So, again in the Error Bar Format menu, set the Join Type to Round and the Begin Arrow Type to the circle (it’s worth noting that Excel 2011 flips what begin and end represent). We just need to format the error bars to look like lollipops. When you set the fill on the bars to No Fill you end up with horizontal lines. Now we’ll format the error bars: In the Format Error Bars menu, select the option for “Minus”, “No Cap”, and set “Percentage” in the Error Amount menu to 100%. In a bar chart, you are only able to add horizontal error bars, so you get the standard-looking thing with an error bar above and below the end of the bar. Now select the bars and add error bars (select the Error Bars option in the Chart Elements menu). We’re going to start by creating a simple bar chart. I’m also going to use the same data Stephanie used in her post. I’ll use Excel 2013 here, but the approach is basically the same on all modern versions of Excel. In this post, I want to show you an alternate way to make a lollipop graph.
I use that general approach when I create dot plots in Excel, but I don’t manually insert and edit the labels that, however, is a post for a different time. Stephanie’s approach to making the lollipop chart in Excel 2013 was to create two scatterplots, one for the points and another for the labels, which were then manually edited one at a time. (Alternatively, you might think of it as a dot plot with only one dot and the lines all stretch to the axis.) The lollipop graph reduces a lot of the ink on the page and I think helps the reader focus just on the end where the data are encoded. If you’re not familiar with the lollipop graph, it’s basically a bar chart except that the end of the bar is replaced with a dot (the candy) and the bar itself is replaced with a line (the stick, if you will). Yesterday, Stephanie Evergreen published a post about how to make a lollipop graph using Excel 2013. But neither are default chart types in Excel, which, believe it or not, is still the primary data visualization tool for most of the world (I have no data to back that up, but I’m telling you it’s true). You probably know that I’m a big fan of slope charts.
0 kommentar(er)
