Plot Data from Excel File in Matplotlib – Python

Matplotlib is a comprehensive library for creating static, animated, and interactive visualizations in Python. It is a plotting library for the Python programming language and its numerical mathematics extension NumPy. In this article, we will learn how to plot data from an excel file in Matplotlib.

If you had not installed the Matplotlib and Pandas library you can install them using the pip command as follows:

pip install matplotlib
pip install pandas

Excel Data Used

You can download the above excel sheet from here.

Plot Data from an Excel File in Matplotlib

Here, we can plot any graph from the excel file data by following 4 simple steps as shown in the example.

Example 1

Import Matplotlib and Pandas module, and read the excel file using the Pandas read_excel() method. After reading data for the x-axis and y-axis from the excel file. Plot the graph using the Matplotlib library. Here, we are plotting a bar graph hence using the bar() method and the show() method to display the graph.

Python3

import matplotlib.pyplot as plt
import pandas as pd
file = pd.read_excel('data.xlsx')
x_axis = file['X values']
y_axis = file['Y values']
plt.bar(x_axis, y_axis, width=5)
plt.xlabel("X-Axis")
plt.ylabel("Y-Axis")
plt.show()

Output:

Example 2

Now, we can plot other graphs and charts by using data from an excel file. Let’s plot a pie chart from the excel file which we used earlier.

Python3

import matplotlib.pyplot as plt
import pandas as pd
file = pd.read_excel('data.xlsx')
plt.pie(file['Value'],labels=file['Label'])
plt.show()

Output: