Bar/scatter graph with VLOOKUP

lyndallmac , with some manual work, a chart like below can be made in which the solid markers denote out, blank markers denote in and colorful markers denote barking scale.

If a sufficiently big area is selected for charting, then i believe this should be flexible for new data appended over new rows.

Steps are mentioned in the attached excel file.

It's not the perfect way i guess, but one is able to do with no much skills other than just plotting scatters, copy pasting charts over one another, and formatting the markers.

and yes, for x-axis , add date and time first and then plot the charts.

y axis 2-3-4-5 can be overwritten with L-A-T-M text boxes.

Blank cells are automatically and undesirably plotted by excel as 0 , so the indexing for L is started from 2 onwards.

This enables to hide the y=0 line which has the undesired blank=0 markers by setting the y axis start as 1.