Outline

  1. Exporting data from excel

  2. Saving ggplot2 plots

  3. using tidyr

Exporting data from Excel

For practice, you can download the buckeye data from my website here: https://jofrhwld.github.io/data/buckeye.xls

What the menus look like will differ from one version of excel to another, and from one operating system to another, but what your goal will be is to save this excel file as a tab-delimited text file. Here’s what that looks like on Excel 2011 for Macs.

With the file open in Excel, go to File > Save as