Filling daily data in gaps

[Jules1995]

Hello everyone,

I have a question about my data and how to manage this without spending insane amounts of time on it.

Please check out my data below:
(It is data regarding irrigation in 2018 retrieved from a model I am using to write my thesis)
I just copy-pasted it in here, so it probably will not look the greatest, but you will get what I am looking for,

Crop name Date Irrigation (cm)
Grass 20-4-2018 2.2
Grass 6-5-2018 1.9
Grass 10-5-2018 2
Grass 16-5-2018 2.2
Grass 22-5-2018 2.1
Grass 29-5-2018 2.3
Grass 6-6-2018 2.1
Grass 11-6-2018 2.1
Grass 17-6-2018 2.3
Grass 24-6-2018 2.3
Grass 28-6-2018 2
Grass 2-7-2018 2.6
Grass 5-7-2018 2
Grass 9-7-2018 2.2
Grass 14-7-2018 2.2
Grass 18-7-2018 2.2
Grass 22-7-2018 2.1
Grass 26-7-2018 2.2
Grass 30-7-2018 2.3
Grass 3-8-2018 2.2
Grass 7-8-2018 2.3
Grass 20-8-2018 2.3
Grass 5-9-2018 2
Grass 12-9-2018 2
Grass 19-9-2018 2.2
Grass 7-10-2018 2
Grass 15-10-2018 2.2

As you can see the model gives me data per day for 2018. However, when there is no irrigation, the model simply leaves these days out.
I want to make a graph showing the amount of irrigation per day, including the days that there is no irrigation, so 0 for these days.
Is there a way to do this easily? Without me having to do a lot of work and adding in all the days that are 0.

Thanks in advance.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Jules1995]

Heres the excel file. It contains multiple crops and grass..
I want to add all of them into one graph, also showing the days that are not included with 0.

[Jules1995]

I posted the excel file.

[JeteMc]

Here is a proposal that only takes a few minutes to implement. (modeled for the data in A1:C28 as shown in columns T:V)
1. Copy A1:C2 and paste to T1,
2. Paste the one of the following into U3: =IF(SUM(U2,1)>B$28,"",SUM(U2,1)) or just =SUM(U2,1)
3. Calculate the number of rows needed (cell X2) using: =B28-B2
4. Goto U180 and press the Ctrl + up arrow keys
5. Press Ctrl + d
6. Move the cursor over to T180 and press the Ctrl + up arrow keys
7. Press Ctrl + d
8. Paste the following formula into cell V3: =IFERROR(INDEX(C$3:C$28,MATCH(U3,B$3:B$28,0)),0)
9. Double click the fill handle to copy down.
Let us know if you have any questions.