Enter the dates in column A and the data in column B. If you enter the dates only as months, Excel automatically formats the chart with evenly spaced, monthly data.

How to Automatically Put in the Months of the Year in Columns in Excel. Microsoft Excel's automatic data fill-in feature is a time-saver, filling in cells for you so you don't need to manually ...