INNER CODE UNIT · Python

anchor_cell

fzumstein/python-for-excel · sales_report_openpyxl.py:131

    anchor_cell = sheet.cell(row=startrow + nrows + 2, column=startcol)
    sheet.add_chart(chart=chart, anchor=anchor_cell.coordinate)

    # Chart formatting
    chart.y_axis.title = "Sales"
    chart.x_axis.title = summary.index.name
    # Hide y-axis line: spPR stands for ShapeProperties
    chart.y_axis.spPr = GraphicalProperties(ln=LineProperties(noFill=True))

View source record →