Skip navigation
This discussion is archived

Kite Diagrams?

4956 Views 10 Replies Latest reply: Mar 3, 2010 5:21 PM by Badunit RSS
kendals Calculating status...
Currently Being Moderated
Mar 3, 2010 6:28 AM
To any scientists who use kite diagrams— is it possible to do these in Numbers '09? I can get it in Excel with the help of a VB addon called Merlin, but can't for the life of me get Numbers to format a tidy Kite Diagram...

Thanks in advance!
Unibody MBP 17" 2.93Ghz, Mac OS X (10.6.2)
  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Mar 3, 2010 7:37 AM (in response to kendals)
    Ken,

    What have you tried so far and what didn't you like about the result?

    Jerry
    iMac G5 2G RAM, Mac OS X (10.5.8)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Mar 3, 2010 9:50 AM (in response to kendals)
    If I undertand what you are looking for, plotting an area diagram of

    1) Your data as one series and
    2) The negative of your data as another series and
    3) Setting the two colors the same

    will give a kite-like diagram of a single data set. Is that what you've done so far? Multiple data sets would require a different method.

    Can you post a screen shot or image of what you are looking to do?
    Mac Pro 2008, Mac OS X (10.5.6)
  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Mar 3, 2010 10:54 AM (in response to Badunit)
    badunit,

    The way I get it is that the method is generally used to compare two sets of similar data, so for instance, sample set one would be plotted above the line and sample set two would be plotted below the line, producing a somewhat mirror image. I don't know what the advantage is, but it seems to be popular in the life sciences.

    Jerry
    iMac G5 2G RAM, Mac OS X (10.5.8)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Mar 3, 2010 11:40 AM (in response to Jerrold Green1)
    The ones I saw online were actual mirror images with "species presence recorded around an invisible central axis to produce a series of kite-like shapes which show species fading in and out along the transect."

    This is easy to do with a single data set using Y=0 as the central axis. To create a single series above the zero line is still pretty easy using a stacked area chart and some simple math. Getting two or more series on a chart I have not figured out other than with overlying charts.
    Mac Pro 2008, Mac OS X (10.5.6)
  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Mar 3, 2010 12:16 PM (in response to Badunit)
    For a single series, you could plot Y and -Y on an Area Chart, then just set the colors the same for both halves.

    Jerry
    iMac G5 2G RAM, Mac OS X (10.5.8)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Mar 3, 2010 12:40 PM (in response to Jerrold Green1)
    That's what I was describing in my first post. I've also seen kite diagrams where the X axis wasn't the centerline. But it's easy to make any arbitrary line the center line. It requires charting two columns of transformed data on a stacked area chart with the one data set set to no fill color.
    Mac Pro 2008, Mac OS X (10.5.6)
  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Mar 3, 2010 1:55 PM (in response to Badunit)
    Badunit wrote:
    That's what I was describing in my first post.

    Missed that, sorry.

    For multiples, I'd just turn off everything but the series, make one chart for each data set and stack them up.

    You can draw your own lines and lay in the titles.

    Jerry
    iMac G5 2G RAM, Mac OS X (10.5.8)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Mar 3, 2010 4:59 PM (in response to kendals)
    This is two overlaid charts. Is that close to what you're looking for?

    Column C =200-B
    Column D = 2*B
    Column F = 80-E
    Column G = 2*E

    I created a stacked bar chart for C&D and another for F&G. The two series corresponding to C and F I set to no fill in the Graphic Inspector. I removed most of the elements of the second chart, set the chart fill color to none, ensured the two charts had the same max Y value on the axis (before hiding the Y axis value labels), made sure the two charts were the same size, and did a few other things then slid the second chart over the first. Kind of a pain but this is the result.

    I would recommend having a table with the data and another table for the mathematical manipulations and use the second table for creating the chart(s). That's not what I did but I recommend doing it that way. There are also other ways you could manipulate the data and make and overlay charts. You could just chart +/-Y data on multiple charts and overlay them so the Y axis aligns on each but the X axis does not and have one blank chart in there to provide the X and Y axis.

    Mac Pro 2008, Mac OS X (10.5.6)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Mar 3, 2010 5:21 PM (in response to Badunit)
    I tried it with +/-Y charts overlaid on each other. One problem is that it leaves a thin white line down the centerline of the kites. It also didn't seem quite as easy and I could not use the chart legend because the second series in each chart (the -Y data) shows up as an extra colored square in the legend.
    Mac Pro 2008, Mac OS X (10.5.6)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.