# How to Combine Daily and Monthly Data in an Excel Chart – 3 Steps

There are two datasets below. The first one showcases daily data and the second monthly data.

### Step 1 – Extract the Month from the Date

Create two blank columns: Monthly Data and Month.

• Enter the following formula in G5.
`=MONTH(F5:F10)`
• Press ENTER.

The MONTH function will extract the months from the dates in F5:F10. As it’s an array formula, the output will automatically be displayed in G5:G10.

### Step 2 – Using VLOOKUP Monthly Data into Daily Data

To extract monthly data from column H into column C:

• Enter the following formula in C5.
`=VLOOKUP(MONTH(B5),\$G\$5:\$H\$10,2,FALSE)`
• Press ENTER.

Formula Breakdown

• MONTH(B5) extracts months from the data in B5.
• \$G\$5:\$H\$10 is the lookup array.
• 2 refers to the second column in \$G\$5:\$H\$10.
• FALSE refers to the exact match between the output of MONTH(B5) and \$G\$5:\$G\$10.
• VLOOKUP(MONTH(B5),\$G\$5:\$H\$10,2,FALSE) extracts monthly data from column H.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Step 3 – Generate the Chart Combining Daily and Monthly Data

• Select all the column headers of the first dataset.

• Press and hold CTRL & SHIFT.
• Press the down arrow key.

This will select the entire dataset.

• Go to the Insert tab.
• In Charts, click Recommended Charts.

In the Insert Chart dialog box:

• Select All Charts.
• Click Combo.
• Select Clustered Column for Monthly Data and Line for Daily Data.
• Click OK.

This is the output.

Practice here.

## Related Articles

<< Go Back to Data for Excel ChartsExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF