ODWS icon

The Open Door Web Site
HOMEPAGE BIOLOGY HOMEPAGE CHEMISTRY PHYSICS ELECTRONICS HISTORY HISTORY OF SCI & TECH MATH STUDIES LEARNING FRENCH STUDY GUIDE  PHOTO GALLERY
IB BIOLOGY HOMEPAGE TOPIC CHAPTERS SCIENTIFIC INVESTIGATIONS DRAWING IN BIOLOGY DRAWING TABLES ERROR ANALYSIS IN BIOLOGY ICT IN BIOLOGY STATISTICS SCIENTIFIC POSTERS MOLECULAR IMAGES
WS

 

Graphs Index

Graphs, why use them?
Rules for drawing Graphs
Other Types of Graphical Representation

 

These data come from an experiment where blood was mixed with different concentrations of sodium chloride solution. By the effect of osmosis the blood cells burst in dilute solutions but not in concentrated ones. When they burst the red blood cells released the red pigment haemoglobin into their surrounding solution. The amount of redness is measured by a colorimeter. The blood cells should be placed in physiological saline which is a specially prepared solution of sodium chloride in which the cells can survive best.

Data

 

 

Note about this Tutorial

This tutorial has been updated. It was originally published using Excel 2003. The new images are screenshots from Excel 2013.

There may be very slight differences for those of you using Excel 2016 but, essentially, the layout is much the same as Excel 2013.

Download the Excel Data File used for this tutorial to practice with

Excel icon

Graph.xlsx

 

ALL ABOUT GRAPHS

Custom Search

Graph Drawing with MS Excel 2013

Graphical data can be effectively treated using Excel. Most students seem to know how to use it to draw bar charts but Excel can do a lot more.

Enter your data on a spread sheet. Important: Respect the convention for decimal points. It depends upon how your computer is configured, for commas or full stops.

To draw a curve of these data, highlight the data and open the graphing menu and select scattergram.

Note: A scattergram is best for the data we are using in this example since it is not at regular intervals (0, 0.1, 0.3, 0.5 etc.). When data is at regular intervals then a line graph is probably the best option.

There are plenty of scattergram options to choose from.

In this example we have chosen the scattergram with smooth lines and markers.

Graph01

Now select the Chart Elements that will give you choices for the graph title, legend (key), gridlines and data labels.

Graph02

In this example we have selected Axes, Axes Titles, Chart Title and Gridlines.

Give the graph its correct title. A pop-up menu will appear where you can choose the Text Options.

Now label your axes. Again, a pop-up menu will provide you with Title Options and Text Options.

Graph03

Use Chart Elements, Axes and More Options to re-size your graph. In this case the vertical axis can be started at 30% Transmission.

Graph04

Once the title and the axes labels are completed you can take a look at the style and colour options for your graph.

Graph05

Finally, by right-clicking on the graph, you can choose to copy the chart so that it can be pasted into another document.

Graph07

 

The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.

Donate to the Open Door Web Site using PayPal

SITE MAP
WHAT'S NEW?
ABOUT

PRIVACY

COPYRIGHT

SPONSORSHIP

DONATIONS

ADVERTISING

© Paul Billiet 2018
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock