Python Excel 自动生成图表：一键生成柱状图 / 折线图
import pandas as pd
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['Microsoft YaHei']
plt.rcParams['axes.unicode_minus'] = False
def auto_chart(excel_file, x_col, y_col, output='chart.png', kind='bar'):
df = pd.read_excel(excel_file)
fig, ax = plt.subplots(figsize=(10, 6))
if kind == 'bar':
ax.bar(df[x_col], df[y_col], color='#4a90e2')
elif kind == 'line':
ax.plot(df[x_col], df[y_col], marker='o', color='#e94f37')
ax.set_xlabel(x_col)
ax.set_ylabel(y_col)
ax.set_title(f'{y_col} 按 {x_col} 分布')
plt.xticks(rotation=45)
plt.tight_layout()
plt.savefig(output, dpi=150)
print(f"已生成：{output}")
auto_chart('销售数据.xlsx', '月份', '销售额', '销售额趋势.png', kind='line')
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['Microsoft YaHei']
plt.rcParams['axes.unicode_minus'] = False
def auto_chart(excel_file, x_col, y_col, output='chart.png', kind='bar'):
df = pd.read_excel(excel_file)
fig, ax = plt.subplots(figsize=(10, 6))
if kind == 'bar':
ax.bar(df[x_col], df[y_col], color='#4a90e2')
elif kind == 'line':
ax.plot(df[x_col], df[y_col], marker='o', color='#e94f37')
ax.set_xlabel(x_col)
ax.set_ylabel(y_col)
ax.set_title(f'{y_col} 按 {x_col} 分布')
plt.xticks(rotation=45)
plt.tight_layout()
plt.savefig(output, dpi=150)
print(f"已生成：{output}")
auto_chart('销售数据.xlsx', '月份', '销售额', '销售额趋势.png', kind='line')
更新时间：2026-09-14 13:43:04