Thanks for the help. I managed to plot the data (I just wanted to chart the plot in Pythonista). I used the following code.
import os
import matplotlib.pyplot as plt
import openpyxl
from openpyxl import cell, chart, chartsheet, comments, compat, constants, descriptors, drawing, formatting
wb = openpyxl.load_workbook('/private/var/mobile/Containers/Shared/AppGroup/29254C8A-D386-4CDC-B278-AAA57C080F82/Pythonista3/Documents/Prac4.xlsx')
sheet = wb['Tstat']
for i in range(1,sheet.max_row,1):
x1data = sheet.cell(row=i,column=1).value
y1data = sheet.cell(row=i,column=2).value
x2data = sheet.cell(row=i,column=4).value
y2data = sheet.cell(row=i,column=5).value
x3data = sheet.cell(row=i,column=7).value
y3data = sheet.cell(row=i,column=8).value
plt.plot(x1data,y1data,'r^',x2data,y2data,'bo',x3data,y3data,'mv')
plt.show()
Although I could only show points on the plot and couldn’t create a line.