Question

how would you compose a data table and bar graph in excel for the following

Column 1                                  column 2                                              column 3

title is tube                                  title is Temperature Celsius                    title is Thickness of Foam Layer

1. ice bath                                  -13 degrees                                            60 mm

2. room temperature                       24 degrees                                           40 mm

3. boiling in beaker                        65 degrees                                            15 mm

4. steam bath      44 degrees     55 mm      

Answer 1

1. Insert all tha data in excel sheet.

2. Select the complete data.

3. Click on insert--à column--à bar graph--à select any design of your choice.

4. Graph will be inserted on the sheet.

5. Edit accordingly.

Tube name	Temperature in degree celcius	Thickness in mm
Ice bath	-13	60
Room temperature	24	40
boiling in beaker	65	15
steam bath	44	55