Type in the interval that you want to use for the X-axis labels. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern.

How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.