In the spirit of Labor Day, I’ll use some data from the Bureau of Labor Statistics (BLS) showing the top ten occupations in the U.S. The various chart options available to you will be listed under the Charts section in the middle. So it should look like a 3D bell curve if. With your data selected, choose the Insert tab on the ribbon bar. Let’s turn now to how to accomplish this in Excel. What I want to do is get a frequency that fall within the range of x that I specify AND the range of y that I specify. Our goal is to enable our audiences to compare the lengths of the bars (instead of the area between them), so general guidance is to thicken the bars to minimize the surrounding white space. The same gray area goes for optimal spacing between bars. However, if you live in cooler climes and consider Labor Day the symbolic end of summer, your preference might be to say sayonara to white until Memorial Day. As a resident of the muggy Southeast, I’ll be rocking white until fall temperatures arrive in mid-October. Two 3D rows of stacked columns is not an option. Rather, it’s personal preference similar to wearing white after Labor Day (in the U.S., that’s the first weekend in September). You could have a single row of 'floating boxes' by using 3D stacked columns and setting the fill and line colors to none for the first series (the bases), but that is the best you could do. Today’s post is a tactical one: how to adjust the widths of bar charts in Excel (and why you should).īefore we get into the step-by-step, I should mention that there aren’t any strict rules for optimal spacing between bars.
0 Comments
Leave a Reply. |