Enter the same number as your interval unit if you only want Excel to show ... the Format Axis window and apply the changes to your chart. How to Make a Frequency Distribution Graph in Excel ...

The interval between the gridlines in an Excel chart is typically blank, but you can highlight the intervals using an alternating pattern by changing the formatting for the gridlines themselves.