add_data ( data, titles_from_data = True ) projected_pie. splitType = "val" # split by value labels = Reference ( ws, min_col = 1, min_row = 2, max_row = 5 ) data = Reference ( ws, min_col = 2, min_row = 1, max_row = 5 ) projected_pie. append ( row ) projected_pie = ProjectedPieChart () projected_pie. create_sheet ( title = "Projection" ) data =, ,, ,, ] for row in data : ws. title = "Pies sold by category" # Cut the first slice out of the pie slice = DataPoint ( idx = 0, explosion = 20 ) pie. add_data ( data, titles_from_data = True ) pie. append ( row ) pie = PieChart () labels = Reference ( ws, min_col = 1, min_row = 2, max_row = 5 ) data = Reference ( ws, min_col = 2, min_row = 1, max_row = 5 ) pie. From openpyxl import Workbook from openpyxl.chart import ( PieChart, ProjectedPieChart, Reference ) from import DataPoint data =, ,, ,, ] wb = Workbook () ws = wb.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |