title: insert plot from pandas to excel file
body: <p>How can I add the plot of pandas to the second worksheet,I checked <a href="https://stackoverflow.com/questions/50694835/putting-multiple-matplotlib-graphs-into-excel-using-python-3">Putting multiple matplotlib graphs into Excel using Python 3</a>, but they use a different module to write to the excel file. everything is working in code(the bars shows correct output), I just want to add the plot to <code>graph1</code> sheet.
  here is my code so far</p>
  
  <pre><code>import matplotlib.pyplot as plt
  from xlsxwriter import Workbook
  #some code
  ordered_list = csv_columns
  wb=Workbook("New File.xlsx")
  ws=wb.add_worksheet("New Sheet")
  first_row=0
  for header in ordered_list:
      col=ordered_list.index(header)
      ws.write(first_row,col,header)
  row=1
  for product in spider.found_items:
      for _key,_value in product.items():
          col=ordered_list.index(_key)
          ws.write(row,col,_value)
      row+=1
  ws=wb.add_worksheet("graph1")
  df = pd.DataFrame(spider.found_items)
  counts =df.groupby('Merchant 1')['Merchant 1'].count().sort_values(ascending=False)
  counts.plot(kind='bar')
  #counts.plot(kind='bar')
  #add to second worksheet (graph1)
  wb.close()
  </code></pre>