Skip navigation

help with grouping in charts

162 Views 2 Replies Latest reply: Nov 19, 2012 10:25 PM by Barry RSS
xlancelalotx Calculating status...
Currently Being Moderated
Nov 19, 2012 12:00 PM

ok my daughter is doing her science project (fun fun fun), and she tested the elasticity of rubberbands when submerged in different temperatures of water.  As she thought, the ones that sat in the cold broke faster.  I am trying to chart them by temperature.  She did 5 rubberbands and 4 temperatures, but the graph keeps on grouping by temperature, but the rubberbands and not the temperature.  I tried making the data accross a row, then a column with the same results.   The example would be;

 

Header 1rb 1rb 2
rb 3
rb 4

rb 5
32 degrees1819.5191918.75
712120.5211921.

 

 

Looking at the above, when I highlight, say create chart, I get something like this;

 

 

Screen Shot 2012-11-19 at 2.56.38 PM.png

 

so it's grouping by the rubberband and not the temp.  I would like 4 colored bars (each being a temperature like it is there), each one will have 5 rubberbands all the same color next to each other.  So you will have a block of 5 blue (the coldest), then the green, etc.

 

The chart options are limited so not even sure if it can be done but figured I would ask.


Thanks

  • Wayne Contello Level 6 Level 6 (12,650 points)
    Currently Being Moderated
    Nov 19, 2012 6:40 PM (in response to xlancelalotx)

    click the chart.  A control will appear in the upper left corner, click that to change how data is presented:

     

     

    BEFORE:

    Screen Shot 2012-11-19 at 8.37.12 PM.png

     

    AFTER:

    Screen Shot 2012-11-19 at 8.38.02 PM.png

     

     

     

    Here is your data:

    Screen Shot 2012-11-19 at 8.39.25 PM.png

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 19, 2012 10:25 PM (in response to xlancelalotx)

    Click on the chart's icon to select it.

    Look at the Table, which will now show the rows and columns providing data to the chart. At the top left, you'll see a small black square containing three white bars. Click on this square to toggle the orientation of the bars (and the orientation of the series on the table) between vertical and horizontal.

    Picture 15.png

    As you can see from the example, each series is assigned a different colour. In your example above, the 'series' was the temperature. In the example here, the 'series' is the type of rubber band.

     

    If your daughter's hypothesis is that chilled rubber bands can be stretched less than warmed rubber bands before breaking, then your example represents the results of testing that hypothesis better than mine. Each group on your graph shows the result for sample of the same type of band stretched at different temperatures. If her hypothesis is supported, the general pattern in each group would show lengthening bars from left to right (as is shown for types 1, 2, 3 and 5).

     

    An even more effective representation of the results might be a horizontal bar chart, such as Cart 2 below. Same data selection as in your example, but with the bars running left to right.

    Picture 16.png

    Best wishes for success in the Science Fair.

     

    Regards,

    Barry

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.