Change the overlap or spacing of data markers in bar and column charts

Office Web Component Chart

Change the overlap or spacing of data markers in bar and column charts

  1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.

  2. Click the chart workspace (the blank area between the plot area and the chart boundary).

  3. On the toolbar, click Commands and Options , and then click the General tab.

  4. 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.