How to add a simple line to a graphic

[ad.dias]

Hey guys,
I had help from a forum member a couple of months ago on a similar topic, but I can't seem to apply it to my file (see atached)
I basically need to add some lines to my original graphic, identifying the wetting season and the drying season, but I have no idea how to do it.

Here is the original graphic:
https://ibb.co/fbBj8F

Here is what I'm looking for:
https://ibb.co/h1K48F

I added the lines trough paint, just to clarify what I’m looking for. It doesn't have to be exactly as I demonstraded, I just want to convey that idea, any suggestion?


Thanks in advance!

 

[Hui]

This is the original post which includes my response:
http://forum.chandoo.org/threads/how-to-add-info-to-a-graphic.34588/

The chart is a Scatter Chart
It adds the lines by adding several extra series which are linked directly to cells on the worksheet

Have you examined the series and the ranges?
Can you post this new data into that file ?

 

[ad.dias]

Hi there hui!
Yes I copied my data into your excel file, but I get completely different graphics from the values I entered (see pictures and attached file)
Why does this happen?

 

[ad.dias]

Hi there hui!
Yes I copied my data into your excel file, but I get completely different graphics from the values I entered (see pictures and attached file)
Why does this happen?

Oh I think I get it, you are using daily values, but I'm using hourly values, is there a way to convert your formula to hourly values?

 

[Hui]

You are close except you missed the underlying issues

The chart uses Column A as the X-Axis values
But you only had X Axis Values down to row 367
in A2: =Int(B2)
then copy that down to the bottom of the data Row 8738

Next each of the 4 data series was only extended down to Row 367
so select each series and edit the =Series() forula in the Formula Bar to extend the charts down to 8738
eg:
Old: =SERIES(Sheet1!$F$1,Sheet1!$A$2:$A$367,Sheet1!$F$2:$F$367,4)
New: =SERIES(Sheet1!$F$1,Sheet1!$A$2:$A$8738,Sheet1!$F$2:$F$8738,4)
Same for the other 3 data Series

Then adjust the X-Axis so that it extends from 1/1/2024 to 31/12/2024

Finally adjust the two cells that control the size of the Horizontal Bars, they both have formula



The results are shown as:


See attached file:

 

[ad.dias]

Hui saves the day again, thanks =D