Python XlsxWriter - Pie Chart

A pie chart is a representation of a single data series into a circle, which is spanided into spces corresponding to each data item in the series. In a pie chart, the arc length of each spce is proportional to the quantity it represents. In the following worksheet, quarterly sales figures of a product are displayed in the form of a pie chart.

Working with XlsxWriter Pie Chart

To generate the above chart programmatically using XlsxWriter, we first write the following data in the worksheet.

headings = [ Category ,  Values ]
data = [
   [ Q1 ,  Q2 ,  Q3 ,  Q4 ],
   [125, 60, 100, 80],
]
worksheet.write_row( A1 , headings, bold)
worksheet.write_column( A2 , data[0])
worksheet.write_column( B2 , data[1])

A Chart object with type=pie is declared and the cell range B1:D1 is used as value parameter for add_series() method and the quarters (Q1, Q2, Q3 and Q4) in column A are the categories.

chart1.add_series({
    name :  Quarterly sales data ,
    categories : [ Sheet1 , 1, 0, 4, 0],
    values : [ Sheet1 , 1, 1, 4, 1],
})
chart1.set_title({ name :  Pie Chart of Quarterly Sales })

In the pie chart, we can use data_labels property to represent the percent value of each pie by setting percentage=True.

Example

The complete program for pie chart generation is as follows −

import xlsxwriter

wb = xlsxwriter.Workbook( hello.xlsx )
worksheet = wb.add_worksheet()

headings = [ Category ,  Values ]
data = [
   [ Q1 ,  Q2 ,  Q3 ,  Q4 ],
   [125, 60, 100, 80],
]
bold=wb.add_format({ bold :True})
worksheet.write_row( A1 , headings, bold)
worksheet.write_column( A2 , data[0])
worksheet.write_column( B2 , data[1])

chart1 = wb.add_chart({ type :  pie })
chart1.add_series({
    name :  Quarterly sales data ,
    categories : [ Sheet1 , 1, 0, 4, 0],
    values : [ Sheet1 , 1, 1, 4, 1],
    data_labels : { percentage :True},
})
chart1.set_title({ name :  Pie Chart of Quarterly Sales })

worksheet.insert_chart( D2 , chart1)

wb.close()

Output

Have a look at the pie chart that the above program produces.

Doughnut Chart

The doughnut chart is a variant of the pie chart, with a hole in its center, and it displays categories as arcs rather than spces. Both make part-to-whole relationships easy to grasp at a glance. Just change the chart type to doughnut.

chart1 = workbook.add_chart({ type :  doughnut })

The doughnut chart of the data in above example appears as below −