Appendix C: Using Excel to Process Data and Make Graphs

Excel: a scientist’s best friend or worst nightmare?  Like it or not, spreadsheets play an important role in organizing and plotting data.  Excel (and to some extent Google Sheets) include commands to make your life easier – if you know how to use them.

Here, we compile useful tutorials and resources for excelling in your Excel skills.

References (Online)

Ben Ryder (9/1/2016) Plotting scientific graphs in Excel (physics).

Ben Ryder (9/1/2016) Using Error bars in Excel with scientific data.

Doug McNally (10/16/2016) How to make a scientific graph in Excel.

Licenses and Attributions

Text written by Elizabeth Johnson, JMU

CC-by License