import matplotlib.pyplot as plt
import pandas as pd
#Please adjust to your file
df=pd.read_excel("/Users/davidmika/Desktop/First.xlsx","Sheet1")
# Group sum of sales at gender level
var = df.groupby('Gender').Sales.sum()
fig = plt.figure()
ax = fig.add_subplot(1,1,1)
#Here you can change labels and title
ax.set_xlabel('Gender')
ax.set_ylabel('Sum of Sales')
ax.set_title("Gender wise Sum of Sales")
var.plot(kind='bar')
#Show bar chart
plt.show()