What type of graph and how?

  • Thread starter Thread starter july11
  • Start date Start date
J

july11

I need to help my daughter graph her results of her scienc
experiement...Which is the strongest paper towel? She used 3 brands o
paper towel. She used 3 items each of a different weight. She trie
the 3 items on the 3 brands for the first round. None broke. Th
second round she doubled the weight of each of the 3 items. One pape
towel brand failed on all 3. The third round she tripled the weight o
each of the 3 items. Only one paper towel brand withheld all 3 items.


Can't figure out how to graph this. 3 paper towel brands, 3 items o
different weights, the 3 items increased in weight over 3 rounds, som
passed and some failed
 
I think the only data that would be of value in the chart
would be Brand vs. Max Weight, you may wish to acompany
it with the rest of the data by placing the chart on the
same sheet as the data.
HTH
Kevin
 
In addition to Kevin's suggestion, how about...

Brand1 Brand2 Brand3
Round 1 1 1 1
Round 2 1 1 1
Round 3 1 1 1

Create a line chart (use the Stacked Line subtype). Specify the data
are in rows. So, the brands will be on the the x-axis.

Now, format each point according to the following rule:
If the brand holds all three items, color that point green.
If it holds two items, use yellow.
If it holds only one item, color it orange.
If it fails to hold any of the three items, color it red.

To color an individual item, click on the series. Pause. Then double
click that point. If done correctly, the resulting dialog box will be
named 'Format Data Point'.


--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top