Charts and sparklines are ... for showing the values in the sample data set. Tip: If Excel has trouble understanding elements of your data set — for example, failing to recognize column headers ...

Excel measures the distance between data points in a chart as a percentage. For example, if the gap width is 50%, the space between each column is half the width of the columns themselves.