**Making graphs in Excel**

**Download directions for making graphs from scratch in Excel
(pdf file)**

or

**Download a template** ((Right click or CTRL-click
on the link. Drag down to something like "Save Link Target as..."
or "Save this Link as..." or "Download Link to Disk" or
"Download Linked File As..." or "Saved Linked File to Desktop...".
Open the saved file in Excel.)

**Excel 2010 or later should use the xlsm version and Excel 1997-2004 should use the xls version.** Excel 2008 for Mac does not work with either version.

More than one set of data may be plotted on the same graph. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
graph.xlsm or graph.xls |

A line can be fit to the data. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
linear.xlsm or linear.xls |

Determines unknown with standard deviation for calibration curve standards. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
aa.xlsm or aa.xls |

Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
histogram.xlsm or histogram.xls |

Plots titration data for the purpose of visually locating the endpoint. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
pH_titration.xlsm or pH_titration.xls volts_titration.xlsm or volts_titration.xls |

Determines intersection of two lines from x-values in column A and y-values in columns B and C. Cut data from B to C to change which data point belongs which line. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
linear2.xlsm or linear2.xls |

Determines unknown with statistics for calibration curve standards. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
calibration.xlsm or calibration.xls |

Determines x-intercept with statistics for standards added to a constant amount of sample. Excel will give a macro warning because this sheet uses macros to make plots. Enable the macros to make the buttons work. |
std_addition.xlsm or std_addition.xls |

Last updated
February 26, 2012
by George Lisensky