Got a different version No problem, you can still follow the exact same steps.

Using different-colored lines in a line graph is much clearer.

In fact, in their most basic form, they only contain one thing: a line.

Youre going to be hard-pressed to find someone who doesnt understand the information you present in a line chart.

They can be represented on other types of charts, but its easy for them to become obscured.

A stacked column chart or a pie chart would be better there.

In the Charts group, click the Insert Line or Area Chart Button.

Select one of the templates from the menu and youll get a specific combination of elements.

One last step: just let us know where should we should send it.

You can also use this value directly as input to MONTH Function.

Let understand the working of MONTH in excel by some examples.

Line Graph With Month Excel Serial Number 40179

For example, the date Jan 1, 2010, is equal to the serial number 40179 in Excel.

MONTH Formula in Excel takes as input both the date directly or the serial number of the date.

It is to be noted here that Excel does not recognize dates earlier than 111900.

You want to find the month name of each of these given dates.

To do so, you can use the following MONTH Formula in Excel for the first month given in E4.

MONTH function in Excel will return 1; 1; 2; 3; 4; 5; 6; 6; 8; 9; 10; 11; 12.

You are supposed to compare the sales between 2016 and 2017 for each month.

MONTH function in Excel will return a matrix 2; 8; 3; 2; 1; 7; 2; 5; 9; 6; 12; 11; 4; 10.

For the 1st month, it will return FALSE; FALSE; FALSE; FALSE; TRUE; FALSE; FALSE; FALSE; FALSE; FALSE; FALSE; FALSE; FALSE; FALSE.

It will give the VALUE error when the input date is earlier than 1 Jan 1900.

Line Graph With Month Excel How To Use MONTH

Here we discuss the MONTH Formula in excel and how to use MONTH function along with excel example and downloadable excel templates.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.