Nov-22-2022, 06:54 AM
Hi all,
I want to use openpyxl make LineChart as Line with markers style.
when run code get new chart need to modify Horizontal axis crosses-->Axis Value to -2.2 that can show normally.
Where could get the parameter about "the Horizontal axis crosses-->Axis Value", thanks in advance!
I want to use openpyxl make LineChart as Line with markers style.
when run code get new chart need to modify Horizontal axis crosses-->Axis Value to -2.2 that can show normally.
Where could get the parameter about "the Horizontal axis crosses-->Axis Value", thanks in advance!
import openpyxl from openpyxl.chart import Reference, LineChart from openpyxl.chart.axis import DateAxis from random import randint wb = openpyxl.load_workbook('offset_demo.xlsx') sheet = wb.active values = Reference(sheet, min_col=3, max_col=37, min_row=1, max_row=152) chart = LineChart() chart.height=13 chart.width=32 chart.add_data(values, titles_from_data=True) dates=Reference(sheet,min_col=1,min_row=2,max_row=152) chart.set_categories(dates) chart.legend=None chart.y_axis.crossAx=500 chart.y_axis.scaling.min=-2 chart.y_axis.scaling.max=0.5 chart.x_axis=DateAxis(crossAx=100) chart.x_axis.number_format='dd-mm-yy' chart.x_axis.majorTimeUnit='days' for i in range(0,35): s1 = chart.series[i] s1.marker.symbol = "auto" s1.graphicalProperties.solidFill ="%06x" % randint(0,0xFFFFFF) s1.marker.graphicalProperties.line.solidFill ="%06x" % randint(0,0xFFFFFF) s1.graphicalProperties.dashStyle = "dash" s1.graphicalProperties.line.width = 1000 chart.title = "OffSet Trend" chart.x_axis.title = "Date" chart.y_axis.title = "Offset Value" sheet.add_chart(chart,"A2") wb.save("offset_demo.xlsx")