Nov-26-2022, 05:44 AM
Hi All,
Is there any way to overwrite linechart in excel?It get more chart in excel during running *.Py code. Please refer to attachment file.
If have a way to delete exist chart and then run code once get a new chart, thanks in advance!
Is there any way to overwrite linechart in excel?It get more chart in excel during running *.Py code. Please refer to attachment file.
If have a way to delete exist chart and then run code once get a new chart, thanks in advance!
import openpyxl
from openpyxl.chart import Reference, LineChart, Series
wb = openpyxl.load_workbook('wb2.xlsx')
sheet = wb.active
# Data for plotting
# Choose all the data from Column 2 to 4
values = Reference(sheet,
min_col=2,
max_col=10,
min_row=1,
max_row=38)
# Create object of LineChart class
chart = LineChart()
chart.add_data(values, titles_from_data=True)
# set the title of the chart
chart.title = "Analysis Stock prices"
# set the title of the x-axis
chart.x_axis.title = "Date"
# set the title of the y-axis
chart.y_axis.title = "Stock Value"
# the top-left corner of the chart
# is anchored to cell F2 .
sheet.add_chart(chart,"F2")
# save the file
wb.save("wb2.xlsx")
