×
英语
很抱歉。本文没有你的语言版本。

Overlap or space data markers in bar and column charts

You need to select only a single data series to change the overlap or spacing of all data series of the same chart type.

  1. Click a data series in the chart you want to change.

  2. On the Format menu, click Selected Data Series, and then click the Options tab.

  3. To change the overlap of the data markers in each category, enter a value between -100 and 100 in the Overlap box. The higher the value, the greater the overlap within the category.

  4. To change the spacing between categories of data markers, enter a value between 0 (zero) and 500 in the Gap width box. The higher the value, the greater the distance between each category.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×