Your presentation-development partner … demonstrate and inspire!

Breaking bars/columns if the range of data being presented is too broad

A good data-driven chart should be easy to read and all elements of the chart should be visually apparent. Sometimes, however, when ranges of data are too broad, some of the data is lost. Look at the example below. The range is so vast that the majority of the segments aren't even apparent.

You can break this chart into three different charts with three different scales. You can also break the largest bar as shown below. At least you can see the segments for the smallest.

The way to break the bar is to put in a dummy number for the 191: in this case it is 80. Manually change the "80" to "191" (not in the worksheet, but on the plotted chart) and place a spacer on the bar. You can use the scale breaks in to003 for the spacers or you can use the shape below out of the basic shapes menu. Just make it white fill with no line color if you use it on a white background or match the background color as the fill, then size it appropriately.


| More