Hi everyone!

I´m trying to build a line graph (series), but I cant match the results I need.

So I have this table, generated from a form that measures water levels from different ponds at different time. (It´s an engaging community wildlife monitoring project, so anyone will be able to report at anytime on any WaterPond)

I need to build a line graph which has the water level (y) of the different ponds (series), over time (x).

I´ve tried using this data but it shows only one line (series) with all the events where waterlevel was measured, but it doesnt differentiate between WaterPonds.

I believe the way I structured the form wont allow me to do this, so I restructured the data on a new table on GSheets like this using vlookup:

One problem is solved, I have different Series for each waterpond.

The problem now is that each event carries a N/A or “0” result for the ponds that were not measured at that same time.

This means that for each date or event, I get 3 values: one correct number for the pond measured, and two zeros for those that weren´t measured

Meaning that the series drops to zero those days that the pond wasnt measured.

Im stuck here now, and Im pretty sure Im overthinking this and there´s an easy solution for this…

I hope someone has an idea that can help me unlock this thing.

Thanks for reading!