Openpyxl Adding chart to Excel File




  • Charts are effective to represent the data. Using the charts, it visualizes the data which may be easily untestable.
  • There are various types of chart: chart , line chart, bar chart, and so on. we will draw a chart on a spreadsheet using an openpyxl module.
  • For building any chart on the spreadsheet, we'd like to define the chart type like BarChart, LineChart, and so on.
 Adding Bar Chart

Adding Bar Chart

Sample code

from openpyxl import Workbook  
from openpyxl.chart import BarChart, Reference  

wb = Workbook()  
sheet = wb.active

# Let's create some sample student data  
rows = [  
    ["Serial_no", "Roll no", "Marks"],  
    [1, "101", 55],  
    [2, "102", 78],  
    [3, "103", 86],  
    [4, "104", 26],  
    [5, "105", 48],  
    [6, "106", 97],  
    [7, "107", 35],  
]  

fori in rows:  
sheet.append(i)  

chart = BarChart()  
values = Reference(worksheet=sheet,  
min_row=1,  
max_row=8,  
min_col=2,  
max_col=3)  

chart.add_data(values, titles_from_data=True)  
sheet.add_chart(chart, "E2")  

wb.save("student_chart.xlsx")

Output

Read Also

Using line chart

 Line Chart

Line Chart

Sample Code

from openpyxl import Workbook  
from openpyxl.chart import LineChart, Reference  

wb = Workbook()  
spreadsheet = wb.active

# Let's create some sample data  
rows = [  
    ["", "January", "February", "March", "April",  
    "May", "June", "July", "August", "September",  
     "October", "November", "December"],  
    [1, ],  
    [2, ],  
    [3, ],  
]  

for row in rows:  
spreadsheet.append(row)  

for row in spreadsheet.iter_rows(min_row=2,  
max_row=4,  
min_col=2,  
max_col=13):  
for cell in row:  
        cell.value = random.randrange(5, 100)  

chart = LineChart()  
data = Reference(worksheet=spreadsheet,  
min_row=2,  
max_row=4,  
min_col=1,  
max_col=13)  

chart.add_data(data, from_rows=True, titles_from_data=True)  
spreadsheet.add_chart(chart, "C6")  

wb.save("line_chart1.xlsx")  

Output




Related Searches to Openpyxl Adding Chart to Excel File

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×