Change the overlap or spacing of data markers in bar and column charts
-
In the design window, make sure the chart is activated. For instructions, see Help for your design program.
-
Click the chart workspace (the blank area between the plot area and the chart boundary).
-
On the toolbar, click Commands and Options
, and then click the General tab. -
Do one of the following:
- To change the overlap of the data markers in each category, type a number between –100 and 100 in the Overlap box to represent the percentage of overlap you want. For example, at 100, bars or columns overlap each other, while at –100, a bar or column width of space is displayed between each. At 0, bars or columns are adjacent to each other.
-
To change the spacing between categories of data markers, type a number between 0 and 500 in the Gap width box to represent the percentage of gap width you want. For example, at 0, data markers touch; at 100, there is one bar or column width of space between each.