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 to Include Captions in Excel Graphs. Captions are not automatically created by Microsoft Excel, but they greatly assist your reader in understanding the data being displayed in your graph.