The Chartsheet Class

In Excel a chartsheet is a worksheet that only contains a chart.

The Chartsheet class has some of the functionality of data Worksheets such as tab selection, headers, footers, margins and print properties but its primary purpose is to display a single chart. This makes it different from ordinary data worksheets which can have one or more embedded charts.

Like a data worksheet a chartsheet object isn’t instantiated directly. Instead a new chartsheet is created by calling the add_chartsheet() method from a Workbook object:

workbook   = xlsxwriter.Workbook('filename.xlsx')
worksheet  = workbook.add_worksheet()  # Required for the chart data.
chartsheet = workbook.add_chartsheet()
#...
workbook.close()

A chartsheet object functions as a worksheet and not as a chart. In order to have it display data a Chart object must be created and added to the chartsheet:

chartsheet = workbook.add_chartsheet()
chart      = workbook.add_chart({'type': 'bar'})

# Configure the chart.

chartsheet.set_chart(chart)

The data for the chartsheet chart must be contained on a separate worksheet. That is why it is always created in conjunction with at least one data worksheet, as shown above.

chart = workbook.add_chart({type, 'column'})

chartsheet.set_chart(chart)

chartsheet.set_tab_color('#FF9900')