<p>我正在使用OpenPYXL3.0.9</p>
<p>查看源代码以获得一个想法,并实现了这一点:</p>
<pre><code>import openpyxl
chart.x_axis = openpyxl.chart.axis.TextAxis(delete=True)
</code></pre>
<p>下面是更多的代码:</p>
<pre><code>CHART_ROW = 11
CHART_HEIGHT = 12
DATA_TABLE_START_ROW = 34
LENGTH_DIST_START_COL = 1
SPACER_DIST_START_COL = LENGTH_DIST_START_COL + 10
SPACER_RANGE_START_COL = SPACER_DIST_START_COL + 6
</code></pre>
<p></p>
<pre><code> chart = BarChart()
chart.style = style # 1 = black line, 13 = green bold line
chart.title = "Spacer Distribution Summary"
chart.height = CHART_HEIGHT # default is 7.5
chart.width = 7 # default is 15
chart.y_axis.title = 'Target Spacer Frequency'
chart.x_axis = openpyxl.chart.axis.TextAxis(delete=True)
values = Reference(self.sheet,
min_col=SPACER_DIST_START_COL + 1,
max_col=SPACER_DIST_START_COL + 1,
min_row=self.spacer_distribution_first_row,
max_row=self.spacer_distribution_last_row)
series = Series(values, title_from_data=False)
chart.series.append(series)
# chart.legend = None
pos = f"{column_string(SPACER_DIST_START_COL)}{CHART_ROW}"
self.sheet.add_chart(chart, pos)
</code></pre>