Forum Discussion
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.