If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting Multiple Values per Item
Dad needs help w/son's science fair data. 5 types of
balls dropped 30 times each at 3 different heights on 3 different surfaces. Need a concise way to show, visually, how drop height, ball type and surface affected rebound. Currently have line chart w/different line for each balltype showing bounce height, but seems to me I ought to be able to make Excel do something "better". I'd like to have groupings of value points per ball type. Haven't worked on the other variations (surface, drop height) yet. Thanks! |
#2
|
|||
|
|||
Charting Multiple Values per Item
George -
You could make box and whisker charts, which don't show every point but give an indication of the variability within the data set. I'd probably start with a small number of charts, using ball type, drop height, and surface as the categories in the first three charts. Then I'd get fancier, breaking out multiple categories in the same chart. For a clue on setting up data and axis tick labels, see these posts from yesterday: x-axis data labels http://www.google.com/groups?threadm...GP09.phx .gbl Displaying secondary coordinate information http://www.google.com/groups?threadm...upernews.co m George Cabe wrote: Dad needs help w/son's science fair data. 5 types of balls dropped 30 times each at 3 different heights on 3 different surfaces. Need a concise way to show, visually, how drop height, ball type and surface affected rebound. Currently have line chart w/different line for each balltype showing bounce height, but seems to me I ought to be able to make Excel do something "better". I'd like to have groupings of value points per ball type. Haven't worked on the other variations (surface, drop height) yet. Thanks! |
Thread Tools | |
Display Modes | |
|
|