Plotting a graph in R with an excel file requires an excel file with two columns, with the values in the first column representing the x-axis and the values in the second column representing the y-axis.

In this tutorial, we will look at how to plot a graph in R language using an excel file.

**read_excel() Function:**

The read_excel() method is used to import and read an Excel file and is only accessible after the **readxl** library has been imported into the R program.

This read_excel() will read an excel file from the current working directory.

**Syntax:**

read_excel(filepath)

**Parameters**

**filepath:** It is the input file to be read or imported

**Installation of readxl package**

Before we work with this package we must first install it. Type the below command in the R console:

install.packages("readxl")

**Output:**

Installing package into ‘C:/Users/cirus/AppData/Local/R/win-library/4.2’ (as ‘lib’ is unspecified) --- Please select a CRAN mirror for use in this session --- trying URL 'https://cloud.r-project.org/bin/windows/contrib/4.2/readxl_1.4.0.zip' Content type 'application/zip' length 1197616 bytes (1.1 MB) downloaded 1.1 MB package ‘readxl’ successfully unpacked and MD5 sums checked The downloaded binary packages are in C:\Users\cirus\AppData\Local\Temp\Rtmpo5UGo0\downloaded_packages

Here we now work with the plotExcelFile.xlsx

**plotExcelFile.xlsx:**

## Plotting an Excel File Data in R

Given an excel file below is the full approach to plot the given excel file data in r

**plot() function:**

The plot() function is used to plot R objects. By default, this function returns a scatter plot with the parameters provided.

**Syntax:**

plot(x, y, main, xlab, ylab, sub, asp)

**Parameters**

**x:**These are the x coordinates of points present in the plot**y:**These are the y coordinates of points present in the plot**main:**It is the name of the main title of the plot.**xlab:**It is a heading/title for the x-axis**ylab:**It is a heading/title for the y-axis**sub:**It is the name of the subtitle of the plot.**asp:**It is the y/x aspect ratio

**Return Value: **

This plot() function returns a Scatter plot of the x and y values given.

**Approach:**

- Import the readxl package using the library() function
- Pass the Excel file path to be read as an argument to the read_excel() function and store it in a variable.
- Here it reads/imports the given excel file.
- Pass the x and y coordinates of points present in the plot, xlabel, ylabel, main title of the plot as arguments to the plot() function to plot the graph of the given Excel file.
- The Exit of the Program.

**Below is the implementation:**

# Import the readxl package using the library() function library(readxl) # Pass the Excel file path to be read as an argument to the read_excel() function # and store it in a variable. # Here it reads/imports the given excel file. excelFilePath <- read_excel("C:/Users/cirus/Downloads/plotExcelFile.xlsx") # Pass the x and y coordinates of points present in the plot, xlabel, ylabel, # main title of the plot as arguments to the plot() function to plot the # graph of the given Excel file plot(x = excelFilePath$x, y = excelFilePath$y, xlab = "x-axis", ylab = "y-axis", main = "Plotting an Excel File" )

**Output:**

It plots the x,y columns data .