Removing radial lines to 1 every 22.5degrees You should be able to easily expand that to a more finely divided grid of direction and wind speed. ![]() Should look something like =COUNTIFS($B$2:$B$500,">"&leftbearing,$B$2:$B$500,""&leftbearing,$A$2:$A$500,""&$D2,$A$2:$A$500,""&$D3,$B$2:$B$500," Insert -> Radar chart -> Filled area radar.Ĩ) Format the chart as desired (repair any mistakes made along the way).Īs AndyPope noted, the chart shows that essentially all entries are north or west. To get the count of a specified wind direction, I would expect something that "count how many entries are greater than a specified minimum bearing and less than a specified maximum bearing and less than a specified wind speed". ![]() If you are unfamiliar with the COUNTIFS() function, then I would suggest you start here and with the many other examples around the internet of this function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |