Basic Graphing Using Excel

Sweet Tea Sugar Detection

Create Your Data Table in Excel

Note: Column I is the Sum of Columns D, E, F, and G

How to Make a Pie Chart

Taste Rankings at a Single Sugar Concentration (200mM)

Using the Insert Tab, Choose Pie Chart

On the Chart Tools Design Tab, Choose “Select Data”

Click the icon to the right of “Chart Data Range”

Highlight the Data Range, then reclick the icon to the right

Under “Horizontal (Category) Axis Labels, Click on “Edit”

Select labels for data, then click “OK”

Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

Give the Chart a Title

Choose Different Chart Designs Using the Chart Tools Design Tab (some will convert values to % of total)

A Beautiful Graph of Your Data!

13%

35%

40%

13%

Taste Ranking for 200mM Sucrose

01234

How to Make a Line Graph

The Dependence of Sugar Detection (Dependent Variable) on the Sugar

Concentration (Independent Variable)

Using the Insert Tab, Choose 2-D Line Graph

On the Chart Tools Design Tab, Choose “Select Data”

Click the icon to the right of “Chart Data Range”

Highlight the Data Range, then reclick the icon to the right

Under “Horizontal (Category) Axis Labels, Click on “Edit”

Select labels for data, then click “OK”

Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

Give the Chart a Title

Label the Axes Using the Chart Tools Layout Tab

A Beautiful Graph of Your Data!

0 25 50 75 100 200 300 400 500 750 1000 1250 1500 1750 20000

5

10

15

20

25

30

35

40

45

Number of Tasters Across Varying Sucrose Concentrations

Series1

Sucrose Concentration (mM)

Number of Tasters

How to Make a Bar Graph

Taste Rankings at a Single Sugar Concentration (200mM)

Using the Insert Tab, Choose 2-D Column Graph

On the Chart Tools Design Tab, Choose “Select Data”

Click the icon to the right of “Chart Data Range”

Highlight the Data Range, then reclick the icon to the right

Under “Horizontal (Category) Axis Labels, Click on “Edit”

Select labels for data, then click “OK”

Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

Give the Chart a Title

Label the Axes Using the Chart Tools Layout Tab

A Beautiful Graph of Your Data!

0 25 50 75 100 200 300 400 500 750 1000 1250 1500 1750 20000

5

10

15

20

25

30

35

40

45

Number of Tasters Across Varying Sucrose Concentrations

Sucrose Concentration (mM)

Number of Tasters

How to Make a Stacked Bar Graph

Taste Rankings at a Single Sugar Concentration (200mM)

Using the Insert Tab, Choose 2-D Stacked Column Graph

On the Chart Tools Design Tab, Choose “Select Data”

Click the icon to the right of “Chart Data Range”

Highlight the Data Range, then reclick the icon to the right

Under “Horizontal (Category) Axis Labels, Click on “Edit”

Select labels for data, then click “OK”

Change Each Legend Entries (Series) by Highlighting “Series 1” and then Clicking “Edit”

Choose Corresponding Label, then Click “OK”

Repeat with Each Series Label

Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

Give the Chart a Title

Label the Axes Using the Chart Tools Layout Tab

A Beautiful Graph of Your Data!

0 25 50 75 100 200 300 400 500 750 1000 1250 1500 1750 20000%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Number of Tasters Across Varying Sucrose Concentrations

4 3

2 1

0

Sucrose Concentration (mM)

Number of Tasters

Data for Reference

Taste Ranking (4 = very sweet) Sample # Molarity 0 1 2 3 4# Subjects # Yes # No

1 0 40 0 0 0 0 40 0 402 25 39 0 1 0 0 40 1 393 50 36 2 2 0 0 40 4 364 75 28 8 4 0 0 40 12 285 100 11 15 11 3 0 40 29 116 200 5 14 16 5 0 40 35 57 300 2 8 23 7 0 40 38 28 400 1 12 18 9 0 40 39 19 500 0 2 11 14 13 40 40 0

10 750 0 0 10 8 22 40 40 011 1000 0 0 0 1 39 40 40 012 1250 0 0 0 0 40 40 40 013 1500 0 0 0 0 40 40 40 014 1750 0 0 0 0 40 40 40 015 2000 0 0 0 0 40 40 40 0