DIRECTIONS - how to make the M&M graph

1. OPEN MICROSOFT EXCEL

2. MAKE A TABLE LIKE THE ONE BELOW

3. PUT YOUR DATA IN THE TABLE

4. HIGHLIGHT THE ENTIRE DATA TABLE

5. GO TO THE CHART WIZARD

6. CHOOSE A LINE GRAPH

7. THE LINE GRAPH THAT WORKS BEST IS CALLED:

"LINE WITH MARKERS DISPLAYED AT EACH DATA VALUE"

9. ADJUST THE CHART SIZE SO THAT IT LOOKS GREAT

10. CHECK THE PRINT PREVIEW - ADJUST CHART IF NEEDED

11. PRINT YOUR GRAPH, STAPLE IT TO YOUR LAB SHEET

START

Rnd 1

REPRO

Rnd 2

Rnd 3

Rnd 4

REPRO

Rnd 5

Rnd 6

Rnd 7

REPRO

ORANGE

4

4

6

6

5

5

7

6

5

4

6

YELLOW

4

3

4

3

3

3

4

2

1

1

1

BROWN

4

3

4

3

3

3

4

4

3

2

3

BLUE

4

4

6

5

4

3

4

3

2

1

1

RED

4

4

6

5

4

2

3

3

3

3

4

GREEN

4

2

3

3

2

1

1

1

1

0

0