Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Spider diagrams (Excel 2003)

    Hi,

    In a consultaion I heard someone mention using spider diagrams in Excel. I at first thought this was a different name for radar charts but it apparently was not the case. I later Googled for "Spider Diagrams" and Google does not give much in the line of Excel. I do see that there are customized programs to create these diagrams. My question is more exploratory in nature, but I just want to know if anyone has come across Excel Spider Diagrams and if/how this is different to radar charts? Can Excel create these diagrams and if so, what will the spreadsheet structure look like?

    TX
    Regards,
    Rudi

  2. #2
    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: Spider diagrams (Excel 2003)

    It can not be done directly, but depending on what you want to show and do, I don't see a reason it can not be done, it would just take some setup, but could be complex...

    I would do it with an XY scatter in Excel setting up to "draw" in XY coords. [It becomes a "puzzle" to create each drawing. It would become a major challenge to make it generic and create some input setup]. On many ways Powerpoint would be much easier to create it in and then just have excel link to the powertpont picture...

    But there is software already available to do it with less bother, so I am not sure why you would want to do in Excel and have the bother...

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spider diagrams (Excel 2003)

    Steve,

    Tx for the reply.
    I just wanted some form of confirmation that it is something that could be done. I will take your advice and mention your alternatives if this person that mentioned it starts to consider creating it in Excel.
    Regards,
    Rudi

  4. #4
    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: Spider diagrams (Excel 2003)

    Just additional clarification: "could be done" covers a wide range of "ease of doing". There is nothing "built in" and no simple workaround. to do it in excel One is able to create any chart with an XY scatter, but they vary from easy things to very complex and difficult.

    One could, eg, create a chart that from the XY coords of the outline of the "Mona Lisa", but it would be time-consuming (using a scanner and Point reader would be easier than doing it manually) but why comes to mind...

    One could also use a screwdriver to pound in a nail or use a hammer to attach a screw. But using the right tool is generally easier and yields better results...

    Steve

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spider diagrams (Excel 2003)

    Understood...

    PS: Your analagies are very creative! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

  6. #6
    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: Spider diagrams (Excel 2003)

    I try (though some just call them stupid) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    It comes from being a scientist and working with sales and marketing personnel. Some ideas just have to simplified or else you find yourself looking into a room full of the vacant stares of "googly-eyed" people <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

Posting Permissions

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