{"id":2813,"date":"2022-11-29T20:45:32","date_gmt":"2022-11-29T15:15:32","guid":{"rendered":"https:\/\/sheetstips.com\/?p=2813"},"modified":"2022-11-30T17:36:20","modified_gmt":"2022-11-30T12:06:20","slug":"python-plotting-doughnut-charts-in-excel-sheet-using-xlsxwriter-module","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/python-plotting-doughnut-charts-in-excel-sheet-using-xlsxwriter-module\/","title":{"rendered":"Python Program to Plot Doughnut Charts in Excel sheet using XlsxWriter Module"},"content":{"rendered":"<p>In this article, we are going to plot the Doughnut Charts in Excel Sheet using XlsxWrite Module in Python.<\/p>\n<p>Charts are made up of a series of one or more data points. The series are made up of references to cell ranges. To plot the charts on an excel sheet, first create a chart object of the desired chart type ( i.e Stock chart, etc.). After generating chart objects, insert data into them before adding them to the sheet object.<\/p>\n<p>Install the xlsxwriter using the below code<\/p>\n<div>\n<pre>pip\u00a0install\u00a0xlsxwriter<\/pre>\n<\/div>\n<p>Looking in indexes: https:\/\/pypi.org\/simple, https:\/\/us-python.pkg.dev\/colab-wheels\/public\/simple\/<br \/>\nCollecting xlsxwriter<br \/>\nDownloading XlsxWriter-3.0.3-py3-none-any.whl (149 kB)<br \/>\n|\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588| 149 kB 5.0 MB\/s<br \/>\nInstalling collected packages: xlsxwriter<br \/>\nSuccessfully installed xlsxwriter-3.0.3<\/p>\n<p>Recommended Reading On:<a href=\"https:\/\/btechgeeks.com\/python-program-to-find-the-sum-of-all-diagonal-elements-of-a-matrix\/\" target=\"_blank\" rel=\"noopener\"> Python Program to Find the Sum of all Diagonal Elements of a Matrix<\/a><\/p>\n<h2>Program to Plot Doughnut Charts in Excel sheet using XlsxWriter Module in Python<\/h2>\n<p>Below are the ways to plot the Doughnut Charts in Excel Sheet using XlsxWriter in Python:<\/p>\n<ul>\n<li><a href=\"#Plotting_Simple_Doughnut_Chart\">Plotting Simple Doughnut Chart<\/a><\/li>\n<li><a href=\"#Plotting_a_Doughnut_chart_with_rotation_of_the_segments\">Plotting a Doughnut chart with rotation of the segments<\/a><\/li>\n<li><a href=\"#Plotting_a_Doughnut_chart_with_rotation_of_the_segments\">Plotting a Doughnut chart with user defined hole size<\/a><\/li>\n<\/ul>\n<h3 id=\"Plotting_Simple_Doughnut_Chart\">Method #1: Plotting Simple Doughnut Chart<\/h3>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import the xlsxwriter library using the import function.<\/li>\n<li>Pass the excel file path to the Workbook() function of xlsxwriter which is the file we want to create and store in a variable.<\/li>\n<li>Create the new Worksheet using the add_worsheet() function and apply it to the above workbook object and store it in a variable.<\/li>\n<li>Create a new Format object to format cells in spreadsheets using the add_format() method and apply it to the above workbook object.<\/li>\n<li>Here, we created a bold format object.<\/li>\n<li>Add the worksheet data that the charts will use.<\/li>\n<li>Write a row of heading data starting with &#8216;A1&#8217; in the bold format using the write_row() function and apply it to the above worksheet object by passing the argument row number, headings list, and format.<\/li>\n<li>Write the column data that is starting from &#8216;A2&#8217;, &#8216;B2&#8217; using the write_coulmn() function and pass data as an argument to it.<\/li>\n<li>Write a column of data starting from &#8216;A2&#8217;, and &#8216;B2&#8217; respectively.<\/li>\n<li>Using the add_chart() method, create a chart object that can be added to a worksheet.<\/li>\n<li>Pass the type of chart as an argument to the add_chart() function and apply it to the above workbook object.<\/li>\n<li>Using the add series()\u00a0method, you can add a data series with a pattern to a chart.<\/li>\n<li>The gap is used to highlight the patterns.<\/li>\n<li>Add the first series(Bricks) data using the add_series() function.<\/li>\n<li>Configuring the First series.<\/li>\n<li>Below is the Syntax to define ranges [sheetname, first_row, first_col, last_row, last_col].<\/li>\n<li>Set the title to the chartObject using the set_title() function by passing the name as value and key as &#8220;name&#8221; (Here the arguments are object).<\/li>\n<li>Set the style of the chart using the set_style() function.<\/li>\n<li>Add a chartObject to the worksheet with the provided offset values in the top-left corner of a chartObject that is anchored to cell C2.<\/li>\n<li>Close the workbook Object using the close() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlsxwriter library using the import function\r\nimport xlsxwriter\r\n\r\n# Pass the excel file path to the Workbook() function of xlsxwriter \r\n# which is the file we want to create and store it in a variable\r\nworkbookObj = xlsxwriter.Workbook('chartDoughnut1.xlsx')\r\n\r\n# Create the new Worksheet using the add_worsheet() function and \r\n# apply it to the above workbook object and store it in a variable\r\nnewWorksheet = workbookObj.add_worksheet()\r\n\r\n\r\n# Create a new Format object to format cells in spreadsheets using the add_format() method and apply it to the above workbook object.\r\n# Here, we created\u00a0a bold format object. .\r\nboldFormat = workbookObj.add_format({'bold': 1})\r\n\r\n# Add the worksheet data that the charts will use.\r\nheadingsData = ['Category', 'Values']\r\nworksheetData = [\r\n    ['Blue', 'Red', 'Pink'],\r\n    [70, 55, 25],\r\n]\r\n\r\n# Write a row of heading data starting with 'A1' in bold format using the write_row() function\r\n# and apply on the above worksheet object\r\n# by passing the argument rowNumber,headings list,and format.\r\nnewWorksheet.write_row('A1', headingsData, boldFormat)\r\n\r\n# Write the column data that is starting from 'A2','B2' using the write_coulmn() function\r\n# and pass data as argument to it\r\n# Write a column of data starting from\r\n# 'A2', 'B2' respectively .\r\nnewWorksheet.write_column('A2', worksheetData[0])\r\nnewWorksheet.write_column('B2', worksheetData[1])\r\n\r\n# Using the add_chart() method, create a chart object that can be added to a worksheet.\r\n# Pass the type of chart as an argument to the add_chart() function \r\n# and apply it to the above workbook object\r\nchartObj = workbookObj.add_chart({'type': 'doughnut'})\r\n\r\n# Using the add series()\u00a0method, you can add a data series with a pattern to a chart. \r\n# The gap is used to highlight the patterns.\r\n# Add the first series(Bricks) data using the add_series() function \r\n\r\n# Configuring First series.\r\n# Below is the Syntax to define ranges\r\n# [sheetname, first_row, first_col, last_row, last_col].\r\nchartObj.add_series({\r\n    'name':\t 'Doughnut Colour sales data',\r\n    'categories': ['Sheet1', 1, 0, 3, 0],\r\n    'values':\t ['Sheet1', 1, 1, 3, 1],\r\n})\r\n\r\n# Set the title to the chartObject using the set_title() function\r\n# by passing the name as value and key as \"name\" (Here the arguments are object)\r\nchartObj.set_title ({'name': 'Doughnut Types'})\r\n\r\n# Set the style of the chart using the set_style() function\r\nchartObj.set_style(12)\r\n\r\n# Add a chartObject to the worksheet with the provided offset values in the top-left corner of a chartObject that is anchored to cell C2.\r\nnewWorksheet.insert_chart('C2', chartObj, {'x_offset': 25, 'y_offset': 10})\r\n\r\n# Close the workbook Object using the close() function.\r\nworkbookObj.close()\r\n\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2816\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart.jpg\" alt=\"doughnut chart\" width=\"1078\" height=\"533\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart.jpg 1078w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-300x148.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-1024x506.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-768x380.jpg 768w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/p>\n<h3 id=\"Plotting_a_Doughnut_chart_with_rotation_of_the_segments\">Method #2: Plotting a Doughnut chart with rotation of the segments<\/h3>\n<p>Set the chart object&#8217;s set_rotation() method with a definite angle input to plot a doughnut chart with segment rotation on an excel sheet.<\/p>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlsxwriter library using the import function\r\nimport xlsxwriter\r\n\r\n# Pass the excel file path to the Workbook() function of xlsxwriter \r\n# which is the file we want to create and store it in a variable\r\nworkbookObj = xlsxwriter.Workbook('chartDoughnut3.xlsx')\r\n\r\n# Create the new Worksheet using the add_worsheet() function and \r\n# apply it to the above workbook object and store it in a variable\r\nnewWorksheet = workbookObj.add_worksheet()\r\n\r\n\r\n# Create a new Format object to format cells in spreadsheets using the add_format() method and apply it to the above workbook object.\r\n# Here, we created\u00a0a bold format object. .\r\nboldFormat = workbookObj.add_format({'bold': 1})\r\n\r\n# Add the worksheet data that the charts will use.\r\nheadingsData = ['Category', 'Values']\r\nworksheetData = [\r\n    ['Blue', 'Red', 'Pink'],\r\n    [70, 55, 25],\r\n]\r\n\r\n# Write a row of heading data starting with 'A1' in bold format using the write_row() function\r\n# and apply on the above worksheet object\r\n# by passing the argument rowNumber,headings list,and format.\r\nnewWorksheet.write_row('A1', headingsData, boldFormat)\r\n\r\n# Write the column data that is starting from 'A2','B2' using the write_coulmn() function\r\n# and pass data as argument to it\r\n# Write a column of data starting from\r\n# 'A2', 'B2' respectively .\r\nnewWorksheet.write_column('A2', worksheetData[0])\r\nnewWorksheet.write_column('B2', worksheetData[1])\r\n\r\n# Using the add_chart() method, create a chart object that can be added to a worksheet.\r\n# Pass the type of chart as an argument to the add_chart() function \r\n# and apply it to the above workbook object\r\nchartObj = workbookObj.add_chart({'type': 'doughnut'})\r\n\r\n# Using the add series()\u00a0method, you can add a data series with a pattern to a chart. \r\n# The gap is used to highlight the patterns.\r\n# Add the first series(Bricks) data using the add_series() function \r\n\r\n# Configuring First series.\r\n# Below is the Syntax to define ranges\r\n# [sheetname, first_row, first_col, last_row, last_col].\r\nchartObj.add_series({\r\n    'name':\t 'Doughnut Colour sales data',\r\n    'categories': ['Sheet1', 1, 0, 3, 0],\r\n    'values':\t ['Sheet1', 1, 1, 3, 1],\r\n})\r\n\r\n# Set the title to the chartObject using the set_title() function\r\n# by passing the name as value and key as \"name\" (Here the arguments are object)\r\nchartObj.set_title ({'name': 'Doughnut Types'})\r\n\r\n# Set the style of the chart using the set_style() function\r\nchartObj.set_style(12)\r\n# Change the rotation(angle) of the first segment using ther set_rotation() function\r\nchartObj.set_rotation(90)\r\n\r\n  \r\n# Add a chartObject to the worksheet with the provided offset values in the top-left corner of a chartObject that is anchored to cell C2.\r\nnewWorksheet.insert_chart('C2', chartObj, {'x_offset': 25, 'y_offset': 10})\r\n\r\n# Close the workbook Object using the close() function.\r\nworkbookObj.close()\r\n\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2818\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-increased-hole-size.jpg\" alt=\"doughnut chart with increased hole size\" width=\"1047\" height=\"588\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-increased-hole-size.jpg 1047w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-increased-hole-size-300x168.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-increased-hole-size-1024x575.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-increased-hole-size-768x431.jpg 768w\" sizes=\"(max-width: 1047px) 100vw, 1047px\" \/><\/p>\n<h3 id=\"Plotting_a_Doughnut_chart_with_rotation_of_the_segments\">Method #3: Plotting a Doughnut chart with user defined hole size<\/h3>\n<p>Use the set_hole_size() function of the chart object with a specific value(radius) argument to plot a doughnut chart with a user-defined hole size on an excel sheet.<\/p>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlsxwriter library using the import function\r\nimport xlsxwriter\r\n\r\n# Pass the excel file path to the Workbook() function of xlsxwriter \r\n# which is the file we want to create and store it in a variable\r\nworkbookObj = xlsxwriter.Workbook('chartDoughnut3.xlsx')\r\n\r\n# Create the new Worksheet using the add_worsheet() function and \r\n# apply it to the above workbook object and store it in a variable\r\nnewWorksheet = workbookObj.add_worksheet()\r\n\r\n\r\n# Create a new Format object to format cells in spreadsheets using the add_format() method and apply it to the above workbook object.\r\n# Here, we created\u00a0a bold format object. .\r\nboldFormat = workbookObj.add_format({'bold': 1})\r\n\r\n# Add the worksheet data that the charts will use.\r\nheadingsData = ['Category', 'Values']\r\nworksheetData = [\r\n    ['Blue', 'Red', 'Pink'],\r\n    [70, 55, 25],\r\n]\r\n\r\n# Write a row of heading data starting with 'A1' in bold format using the write_row() function\r\n# and apply on the above worksheet object\r\n# by passing the argument rowNumber,headings list,and format.\r\nnewWorksheet.write_row('A1', headingsData, boldFormat)\r\n\r\n# Write the column data that is starting from 'A2','B2' using the write_coulmn() function\r\n# and pass data as argument to it\r\n# Write a column of data starting from\r\n# 'A2', 'B2' respectively .\r\nnewWorksheet.write_column('A2', worksheetData[0])\r\nnewWorksheet.write_column('B2', worksheetData[1])\r\n\r\n# Using the add_chart() method, create a chart object that can be added to a worksheet.\r\n# Pass the type of chart as an argument to the add_chart() function \r\n# and apply it to the above workbook object\r\nchartObj = workbookObj.add_chart({'type': 'doughnut'})\r\n\r\n# Using the add series()\u00a0method, you can add a data series with a pattern to a chart. \r\n# The gap is used to highlight the patterns.\r\n# Add the first series(Bricks) data using the add_series() function \r\n\r\n# Configuring First series.\r\n# Below is the Syntax to define ranges\r\n# [sheetname, first_row, first_col, last_row, last_col].\r\nchartObj.add_series({\r\n    'name':\t 'Doughnut Colour sales data',\r\n    'categories': ['Sheet1', 1, 0, 3, 0],\r\n    'values':\t ['Sheet1', 1, 1, 3, 1],\r\n})\r\n\r\n# Set the title to the chartObject using the set_title() function\r\n# by passing the name as value and key as \"name\" (Here the arguments are object)\r\nchartObj.set_title ({'name': 'Doughnut Types'})\r\n\r\n# Set the style of the chart using the set_style() function\r\nchartObj.set_style(12)\r\n\r\n# set the doughnut hole size using the set_hole_size() function by passing the hole size as an argument to it\r\nchartObj.set_hole_size(33)\r\n  \r\n# Add a chartObject to the worksheet with the provided offset values in the top-left corner of a chartObject that is anchored to cell C2.\r\nnewWorksheet.insert_chart('C2', chartObj, {'x_offset': 25, 'y_offset': 10})\r\n\r\n# Close the workbook Object using the close() function.\r\nworkbookObj.close()\r\n\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2819\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-rotation.jpg\" alt=\"doughnut chart with increased hole size\" width=\"1099\" height=\"522\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-rotation.jpg 1099w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-rotation-300x142.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-rotation-1024x486.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/doughnut-chart-with-rotation-768x365.jpg 768w\" sizes=\"(max-width: 1099px) 100vw, 1099px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we are going to plot the Doughnut Charts in Excel Sheet using XlsxWrite Module in Python. Charts are made up of a series of one or more data points. The series are made up of references to cell ranges. To plot the charts on an excel sheet, first create a chart object &#8230; <a title=\"Python Program to Plot Doughnut Charts in Excel sheet using XlsxWriter Module\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/python-plotting-doughnut-charts-in-excel-sheet-using-xlsxwriter-module\/\" aria-label=\"More on Python Program to Plot Doughnut Charts in Excel sheet using XlsxWriter Module\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":2871,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182],"tags":[],"jetpack_featured_media_url":"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/Python-Program-to-Plot-Doughnut-Charts-in-Excel-sheet-using-XlsxWriter-Module.png","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2813"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=2813"}],"version-history":[{"count":8,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2813\/revisions"}],"predecessor-version":[{"id":4841,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2813\/revisions\/4841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media\/2871"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=2813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=2813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=2813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}