Now, select the fill ... the intervals of the tick marks if activated. Reduce the Gaps Between Bars and Columns Excel measures the distance between data points in a chart as a percentage.