Charting Multiple Values per Item

[George Cabe]

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!

 

[Jon Peltier]

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/[email protected]

Displaying secondary coordinate information
http://www.google.com/[email protected]