先决条件： 使用openpyxl模块在excel工作表中绘制图表 集合–1 | 第二组 Openpyxl 是一个Python库，使用它可以对excel文件执行多种操作，如读取、写入、算术运算和绘制图形。 图表由至少一系列的一个或多个数据点组成。系列本身由单元格范围的引用组成。让我们看看如何使用openpyxl在excel表格上绘制甜甜圈、雷达、曲面、3D曲面图。 为了在excel工作表上绘制图表，首先，创建特定图表类（即SurfaceChart、RadarChart等）的图表对象。创建图表对象后，在其中插入数据，最后将该图表对象添加到图纸对象中。让我们看看如何使用实时数据绘制不同的图表。 代码#1： 绘制油炸圈饼图 甜甜圈图与饼图类似，只是它们使用的是一个环而不是一个圆。它们还可以将多个系列的数据绘制成同心环。要在excel工作表上绘制圆环图，请使用openpyxl中的圆环图类。图表子模块。
null
Python3
# import Workbook from openpyxl from openpyxl import Workbook # import DoughnutChart, Reference from openpyxl.chart sub_module . from openpyxl.chart import DoughnutChart, Reference # import DataPoint from openpyxl.chart.series class from openpyxl.chart.series import DataPoint # Call a Workbook() function of openpyxl # to create a new blank Workbook object wb = Workbook() # Get workbook active sheet # from the active attribute. ws = wb.active # data given data = [ [ 'Pie' , 2014 ], [ 'Plain' , 40 ], [ 'Jam' , 2 ], [ 'Lime' , 20 ], [ 'Chocolate' , 30 ], ] # write content of each row in 1st and 2nd # column of the active sheet respectively . for row in data: ws.append(row) # Create object of DoughnutChart class chart = DoughnutChart() # create data for plotting labels = Reference(ws, min_col = 1 , min_row = 2 , max_row = 5 ) data = Reference(ws, min_col = 2 , min_row = 1 , max_row = 5 ) # adding data to the Doughnut chart object chart.add_data(data, titles_from_data = True ) # set labels in the chart object chart.set_categories(labels) # set the title of the chart chart.title = "Doughnuts Chart" # set style of the chart chart.style = 26 # add chart to the sheet # the top-left corner of a chart # is anchored to cell E1 . ws.add_chart(chart, "E1" ) # save the file wb.save( "doughnut.xlsx" ) |
输出：
![图片[1]-Python |使用openpyxl模块|集3在excel表格中绘制图表-yiteyi-C++库](https://media.geeksforgeeks.org/wp-content/uploads/plot1.png)
代码#2： 绘制雷达图 在工作表上按列或行排列的数据可以绘制在雷达图中。雷达图比较多个数据系列的聚合值。它实际上是面积图在圆形x轴上的投影。要在excel表格上绘制雷达图，请使用openpyxl中的RadarChart类。图表子模块。
Python3
# import Workbook from openpyxl from openpyxl import Workbook # import RadarChart, Reference from openpyxl.chart sub_module . from openpyxl.chart import RadarChart, Reference # Call a Workbook() function of openpyxl # to create a new blank Workbook object wb = Workbook() # Get workbook active sheet # from the active attribute. ws = wb.active # data given data = [ [ 'Month' , "Bulbs" , "Seeds" , "Flowers" , "Trees & shrubs" ], [ 'Jan' , 0 , 2500 , 500 , 0 , ], [ 'Feb' , 0 , 5500 , 750 , 1500 ], [ 'Mar' , 0 , 9000 , 1500 , 2500 ], [ 'Apr' , 0 , 6500 , 2000 , 4000 ], [ 'May' , 0 , 3500 , 5500 , 3500 ], [ 'Jun' , 0 , 0 , 7500 , 1500 ], [ 'Jul' , 0 , 0 , 8500 , 800 ], [ 'Aug' , 1500 , 0 , 7000 , 550 ], [ 'Sep' , 5000 , 0 , 3500 , 2500 ], [ 'Oct' , 8500 , 0 , 2500 , 6000 ], [ 'Nov' , 3500 , 0 , 500 , 5500 ], [ 'Dec' , 500 , 0 , 100 , 3000 ], ] # write content of each row in 1st and 2nd # column of the active sheet respectively . for row in data: ws.append(row) # Create object of RadarChart class chart = RadarChart() # filled type of radar chart chart. type = "filled" # create data for plotting labels = Reference(ws, min_col = 1 , min_row = 2 , max_row = 13 ) data = Reference(ws, min_col = 2 , max_col = 5 , min_row = 2 , max_row = 13 ) # adding data to the Radar chart object chart.add_data(data, titles_from_data = True ) # set labels in the chart object chart.set_categories(labels) # set the title of the chart chart.title = "Radar Chart" # set style of the chart chart.style = 26 # delete y axis from the chart chart.y_axis.delete = True # add chart to the sheet # the top-left corner of a chart # is anchored to cell G2 . ws.add_chart(chart, "G2" ) # save the file wb.save( "Radar.xlsx" ) |
输出：
![图片[2]-Python |使用openpyxl模块|集3在excel表格中绘制图表-yiteyi-C++库](https://media.geeksforgeeks.org/wp-content/uploads/plot2.png)
代码#3： 绘制曲面图 在工作表上按列或行排列的数据可以绘制在曲面图中。当您想要在两组数据之间找到最佳组合时，曲面图非常有用。与地形图一样，颜色和图案表示处于相同值范围内的区域。要在excel工作表上绘制曲面图，请使用openpyxl中的SurfaceChart类。图表子模块。
Python3
# import Workbook from openpyxl from openpyxl import Workbook # import SurfaceChart, Reference, Series from openpyxl.chart sub_module . from openpyxl.chart import SurfaceChart, Reference, Series # Call a Workbook() function of openpyxl # to create a new blank Workbook object wb = Workbook() # Get workbook active sheet # from the active attribute. ws = wb.active # given data data = [ [ None , 10 , 20 , 30 , 40 , 50 , ], [ 0.1 , 15 , 65 , 105 , 65 , 15 , ], [ 0.2 , 35 , 105 , 170 , 105 , 35 , ], [ 0.3 , 55 , 135 , 215 , 135 , 55 , ], [ 0.4 , 75 , 155 , 240 , 155 , 75 , ], [ 0.5 , 80 , 190 , 245 , 190 , 80 , ], [ 0.6 , 75 , 155 , 240 , 155 , 75 , ], [ 0.7 , 55 , 135 , 215 , 135 , 55 , ], [ 0.8 , 35 , 105 , 170 , 105 , 35 , ], [ 0.9 , 15 , 65 , 105 , 65 , 15 ], ] # write content of each row in 1st and 2nd # column of the active sheet respectively . for row in data: ws.append(row) # Create object of SurfaceChart class chart = SurfaceChart() # create data for plotting labels = Reference(ws, min_col = 1 , min_row = 2 , max_row = 10 ) data = Reference(ws, min_col = 2 , max_col = 6 , min_row = 1 , max_row = 10 ) # adding data to the Surface chart object chart.add_data(data, titles_from_data = True ) # set labels in the chart object chart.set_categories(labels) # set the title of the chart chart.title = "Surface Chart" # set style of the chart chart.style = 26 # add chart to the sheet # the top-left corner of a chart # is anchored to cell H2 . ws.add_chart(chart, "H2" ) # save the file wb.save( "Surface.xlsx" ) |
输出：
![图片[3]-Python |使用openpyxl模块|集3在excel表格中绘制图表-yiteyi-C++库](https://media.geeksforgeeks.org/wp-content/uploads/plot3.png)
代码#4： 绘制曲面3D图表 要在excel工作表上绘制三维曲面图，请使用openpyxl中的SurfaceChart3D类。图表子模块。
Python3
# import Workbook from openpyxl from openpyxl import Workbook # import SurfaceChart3D, Reference, Series from openpyxl.chart sub_module . from openpyxl.chart import SurfaceChart3D, Reference, Series # Call a Workbook() function of openpyxl # to create a new blank Workbook object wb = Workbook() # Get workbook active sheet # from the active attribute. ws = wb.active # given data data = [ [ None , 10 , 20 , 30 , 40 , 50 , ], [ 0.1 , 15 , 65 , 105 , 65 , 15 , ], [ 0.2 , 35 , 105 , 170 , 105 , 35 , ], [ 0.3 , 55 , 135 , 215 , 135 , 55 , ], [ 0.4 , 75 , 155 , 240 , 155 , 75 , ], [ 0.5 , 80 , 190 , 245 , 190 , 80 , ], [ 0.6 , 75 , 155 , 240 , 155 , 75 , ], [ 0.7 , 55 , 135 , 215 , 135 , 55 , ], [ 0.8 , 35 , 105 , 170 , 105 , 35 , ], [ 0.9 , 15 , 65 , 105 , 65 , 15 ], ] # write content of each row in 1st and 2nd # column of the active sheet respectively . for row in data: ws.append(row) # Create object of SurfaceChart3D class chart = SurfaceChart3D() # create data for plotting labels = Reference(ws, min_col = 1 , min_row = 2 , max_row = 10 ) data = Reference(ws, min_col = 2 , max_col = 6 , min_row = 1 , max_row = 10 ) # adding data to the Surface chart 3D object chart.add_data(data, titles_from_data = True ) # set labels in the chart object chart.set_categories(labels) # set the title of the chart chart.title = "Surface Chart 3D" # set style of the chart chart.style = 26 # add chart to the sheet # the top-left corner of a chart # is anchored to cell H2 . ws.add_chart(chart, "H2" ) # save the file wb.save( "Surface3D.xlsx" ) |
输出：
![图片[4]-Python |使用openpyxl模块|集3在excel表格中绘制图表-yiteyi-C++库](https://www.yiteyi.com/wp-content/uploads/geeks/geeks_plot4.png)
© 版权声明
文章版权归作者所有，未经允许请勿转载。
THE END
![关于”PostgreSQL错误：关系[表]不存在“问题的原因和解决方案-yiteyi-C++库](https://www.yiteyi.com/wp-content/themes/zibll/img/thumbnail.svg)
