+ Reply to Thread
Results 1 to 3 of 3

Radar Chart overlaid a Quadrant Diagram

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Radar Chart overlaid a Quadrant Diagram

    RadarChart.gifHi All,

    Thanks in advance for any help.
    I'm trying to make a Radar Graph (like the attached example).
    I consider my self reasonably savvy with excel and charts, but the only way I can think of is to overlay 2 x charts - very clunky!

    any suggestions greatly appreciated.

    Thanks
    Last edited by nelg001; 05-02-2014 at 02:12 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Radar Chart overlaid a Quadrant Diagram

    Create the chart using xy-scatter.

    You will need to calculate the radial positions of the data points.

    You can add extra series to draw axes and position data labels containing descriptive quadrent texts
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Radar Chart overlaid a Quadrant Diagram

    WOWZERS! thanks Andy...I still don't have the full gist of how you've done this, but it is certainly a great step forward!

    Thanks for your help.

    Regards

    P.S. can't figure out how to mark this as solved...?

+ 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. [SOLVED] Quadrant chart
    By Agnese in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-17-2013, 05:35 AM
  2. Replies: 1
    Last Post: 06-20-2013, 01:14 PM
  3. Four quadrant chart
    By ChrisF79 in forum Excel General
    Replies: 9
    Last Post: 01-14-2010, 10:15 PM
  4. Quadrant Chart
    By Oriana in forum Excel General
    Replies: 1
    Last Post: 11-14-2007, 02:31 PM
  5. [SOLVED] Creating a chart of overlaid area circles?
    By m.nutt1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-25-2005, 09:10 AM

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