xlwings chart_type

xlwings is a Python package that allows you to interact with Microsoft Excel spreadsheets using Python. It provides a range of functions and methods for working with Excel charts, including the ability to set the chart type.

To set the chart type using xlwings, you can use the `chart.set_chart_type()` method. This method takes a single argument, which is the chart type you want to set.

For example, to set a chart to a line chart, you can use the following code:

import xlwings as xw

# open the workbook
wb = xw.Book('example.xlsx')

# select the chart
chart = wb.sheets['Sheet1'].charts['Chart1']

# set the chart type to line chart
chart.set_chart_type('line')

Other chart types you can set include column, bar, area, scatter, and more. The full list of chart types can be found in the xlwings documentation.