Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Location
    Arlington, Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Radar Charts (2000/2003)

    I have a set of data in three columns that I have been informed needs to be displayed in a Radar Chart.

    Example:

    Item Scheduled Completed
    I1 10 8
    I2 6 1
    I3 8 3

    I am not an expert in radar charts, so I highlighted the three columns, and selected "Radar Chart," but the result was not what I was expecting. What am I missing?

    Thanks,

    wallygator

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Radar Charts (2000/2003)

    Since we don't know what you were expecting, it is impossible to answer your question.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Radar Charts (2000/2003)

    I agree with Hans' comment.

    I would expect that the first column are the "axes labels"
    The second column is the first series of values (scheduled)
    The third column is the second series of values.(complete)

    When I highlight and plot, it gives me exactly that.

    Can you describe what you want the chart to look like?

    Steve

  4. #4
    New Lounger
    Join Date
    Mar 2004
    Location
    Arlington, Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radar Charts (2000/2003)

    Beside clarity in my questions, it appears that my other problem is I cannot get Excel to give me different lengths on my axis. When I normalize the data and create a radar graph using only 2 columns (label and normalized column), I get the expected result.

    wallygator

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Radar Charts (2000/2003)

    I still don't understand what you want. Do you want different scales for the I1, I2 and I3 axes? As far as I know, that is not possible. Or do you want different scales for the two series? You can accomplish that by specifying that one of the series be plotted on the secondary axis (select series, select Format | Selected Series..., activate Axes tab, click Secondary Axis)

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radar Charts (2000/2003)

    I would suggest you ask whoever told you this data should be in a radar chart what they expect that radar chart to look like. Better to get it from that person than for you to try to guess what that person is thinking (experience has taught me this!).

    Then, if they expected each item to have a different scale (10 for I1, 6 for I2, and 8 for I3), you can explain to them that Excel isn't capable of providing such results, and the experts you've consulted support this statement.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Radar Charts (2000/2003)

    [quote] that Excel isn't capable of providing such results, and the experts you've consulted support this statement. [quote]

    I may not be an expert, but excel is "capable", but not capable in a direct manner (ie using a "Radar Chart") you would have to use an XY scatter as a "drawing tool" but it could be done with some "playing" thoug;h it would not be completely generic and it would take some upfront work to create it (it would not be "trivial")

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radar Charts (2000/2003)

    I certainly hope you didn't think I was trying to call myself an expert. And I realized that there was likely a (tedious, non-trivial) workaround...

    That said, wallygator may wish to try going here and see if that helps to give him his expected results. As I have never had cause to use radar charts, I can't say that it will help or not, but it looks like it may be a good starting point.

    - Brett

  9. #9
    New Lounger
    Join Date
    Mar 2004
    Location
    Arlington, Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radar Charts (2000/2003)

    This info in the link was what I was looking for - I was hoping Excel would have this functionality built it, but it does not. The solution that I used was to normalize the data to percentages and graphing that, which went over well; however, following the executive briefing, I was told to change it to bar graphs.

    Thanks to all for the assistance!!!

    wallygator

Posting Permissions

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