The Open Door Web Site

Graphs Index

 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.

 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 Graph.xlsx

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.

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

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.

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

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

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

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

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