Press with left mouse button on OK button. Here press with left mouse button on 'Custom' and type: mmm-yy To format the dates simply select the dates, press CTRL + 1 to open the Format Cells dialog box. My dates in the first dataset start in November 2017 and end in February 2018, this series also has month and year values in the same date range as my first data set. To position dates between tick marks we need an additional series, I am going to use the values displayed to the right. The chart above shows the first date in each month right below tick marks. We want month and year between tick marks, not the entire date below tick marks. This, however, is not what we are looking for. This will change how the x-axis will display the dates, it will begin with and the next tick mark is going to have the first date in the next month. Here you can easily change which date the x-axis begins with and ends with, it also allows you to specify the interval.Ĭhange Major Units from 7 to 1 and also change Days to Months. ĭouble press with left mouse button on with left mouse button on the dates right below the chart x-axis to open the Format Axis Task Pane. The line chart x-axis shows dates with seven days interval to the next tick mark beginning with. The chart shown below is the default chart Excel creates when you insert a line chart. Then press with left mouse button on the 'Insert' tab on the ribbon, press with left mouse button on the 'Line' chart button and a line chart instantly appears. To insert a line chart simply select the values you want to use, I am using the values shown in the image to the right. You will need an additional series and a secondary axis to accomplish this. This tutorial demonstrates in great detail how to position month and year values between chart tick marks.

The picture above shows a line chart with month and year labels between tick marks instead of date values below each tick mark. Author: Oscar Cronquist Article last updated on June 11, 2018

Excel graph axis label month