+ Reply to Thread
Results 1 to 4 of 4

Creating a wind rose-type radar diagram?

  1. #1
    Registered User
    Join Date
    05-07-2018
    Location
    United Kingdom
    MS-Off Ver
    Mac 2016
    Posts
    2

    Question Creating a wind rose-type radar diagram?

    Hello everyone, new here and need some help!

    I have some wind direction data (0-360 degrees) for six sites on a mountain. The figures are averages from a raw data set. The data is based on seven readings (half hour increments 11:00-14:00). I would like to create a wind rose-type of radar chart to display each site's compass directions at each half hour time (line and points linked up). Some may not know what a wind rose is - it's basically a compass shape used by meteorologists to show wind direction. It's very similar to a radar diagram in excel. I just cannot figure out how to configure the data for the chart. Any help would be greatly appreciated. I've attached the data.

    Thanks in advance,
    drefiek1
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Creating a wind rose-type radar diagram?

    Google excel wind rose for many examples.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-07-2018
    Location
    United Kingdom
    MS-Off Ver
    Mac 2016
    Posts
    2

    Re: Creating a wind rose-type radar diagram?

    Hi shg,

    I wouldn't be posting on here if I hadn't already - the examples are far too complex and I am not an Excel whizz. I thought posting on an excel help forum may provide me with some answers.

    Regards,
    drefiek1

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Creating a wind rose-type radar diagram?

    I remember seeing this one some years back:

    https://answers.microsoft.com/en-us/...8-785a4709d4e8

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 06-14-2022, 02:59 AM
  2. How do I create a wind rose in excel?
    By krumpf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2015, 07:12 PM
  3. wind rose
    By mdanaee in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-06-2013, 11:23 AM
  4. Create wind rose from the data in excel
    By jdbaba in forum Excel General
    Replies: 4
    Last Post: 12-18-2012, 07:30 PM
  5. How do I create a wind rose in excel?
    By krumpf in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-05-2012, 07:36 PM
  6. Wind Rose Chart
    By ranallima in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-05-2005, 12:05 AM
  7. how do i plot a rose diagram to show frequency of wind direction
    By kathryn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1