Yes; attached.
As noted above, I think the main issue is that plotting only offers an option for "empty cells as gaps", and after splitting the available text data I have blank or NA cells which are not shown as gaps, and don't know how to have an expression return an empty cell. So all of the attempts below fail.
Basic idea;
Tab "Data" is raw data, downloaded form web site.
tab "Weather" then copies that (Cols A:C) except reversed order.
(to get dates forward order.)
Weather!C20:C234 is the copied data of interest.
It can be:
D nn (Direction, value)
D nn G nn (Direction, value, G, value)
Calm
then cols D:F are the split out values, which are plotted.
I left in a few experiments, trying to adjust the text values from the trim(....) expression.
One was to value() it (fails for blank), another to test for "" and NA() if found,
Another to add 0 to the text value to make it numeric (which fails if blank), then adding iferror() to adjust for those failures (but still needed to return something, and can't make an empty cell).
|