decorative banner

Selecting bar and stacked bar options


    Bar Width and Cluster Width values can range from 1% to 1000%. These values allow space between bars and between clusters. A value of 100% moves both bars and clusters flush against each other. A value above 100% causes the bars and clusters to overlap one another.

    Bar and stacked bar graph options are the same. They include the following:

    • Bar Width, by default, is 90%.
    • Cluster Width is the total width of all bars in a cluster. A cluster is a group of bars that correspond to a row of data in the work sheet. The default cluster width is 80%. If you are using stacked bar graphs exclusively, it is recommended that you set the cluster width to 100% and use only the Bar Width option to adjust the width.