python-pptx-bar

from pptx import Presentation
from pptx.util import Inches
from pptx.chart.data import ChartData
from pptx.enum.chart import XL_TICK_MARK
from pptx.util import Pt
from pptx.dml.color import RGBColor
from pptx.enum.chart import XL_DATA_LABEL_POSITION
from pptx.enum.chart import XL_LEGEND_POSITION
from pptx.enum.chart import XL_CHART_TYPE
from pptx.enum.chart import XL_MARKER_STYLE
from pptx.enum.chart import XL_TICK_LABEL_POSITION
import xlrd

prs = Presentation()

slide = prs.slides.add_slide(prs.slide_layouts[6])  # 在幻灯片中加入一页6号风格（空白）幻灯片

# chart1 左上方图
x, y, cx, cy = Inches(0.5), Inches(0.5), Inches(8), Inches(6)  # 按英尺标准指定x，y值

chart_data = ChartData()  # 图表data类
xl = xlrd.open_workbook("一品三笑10月数据.xlsx")
table = xl.sheet_by_index(2)  # 获取表格内容
rows = table.nrows
shop_name = []
series = []
for i in range(1, rows):
    shop_name.append(table.cell(i, 1).value)
    series.append(table.cell(i, 2).value)

chart_data.categories = shop_name  # 图表加入两栏
chart_data.add_series(u'得分率', series)  # 在两栏分别填入数据

graphic_frame = slide.shapes.add_chart(
    XL_CHART_TYPE.BAR_CLUSTERED, x, y, cx, cy, chart_data)
# add_chart(图表类型，xy表示图表位置，cx cy表示图表宽高，并且插入chart_data中规定好的数据）

chart = graphic_frame.chart  # 从生成的图表中取出图表类
chart.chart_style = 10  # 图表整体颜色风格

chart.has_title = True  # 图表是否含有标题，默认为False
chart.chart_title.text_frame.clear()  # 清除原标题
new_paragraph = chart.chart_title.text_frame.add_paragraph()  # 添加一行新标题
new_paragraph.text = '得分率对比'  # 新标题
new_paragraph.font.size = Pt(15)  # 新标题字体大小

category_axis = chart.category_axis  # category_axis 为chart的category控制类
category_axis.gridlines = False
# category_axis.has_major_gridlines = False  # 是否显示纵轴线

# category_axis.has_minor_gridlines=True
category_axis.tick_labels.font.italic = False  # tick_labels为图表下标签，置为斜体
category_axis.tick_labels.font.size = Pt(10)  # 下标签字体大小
category_axis.tick_labels.font.color.rgb = RGBColor(0, 0, 0)  # 标签字体颜色

category_axis.tick_label_position = XL_TICK_LABEL_POSITION.LOW


value_axis = chart.value_axis  # value_axis 为chart的value控制类
value_axis.maximum_scale = 100.0  # 纵坐标最大值
value_axis.minimum_scale = 70.0  # 纵坐标最小值
value_axis.minor_tick_mark = XL_TICK_MARK.INSIDE
value_axis.has_minor_gridlines = False

tick_labels = value_axis.tick_labels  # tick_labels 为chart的纵轴标签控制类
# tick_labels.number_format = '0%'  # 标签显示样式
tick_labels.font.bold = True  # 字体加粗
tick_labels.font.size = Pt(14)  # 字体大小
tick_labels.font.color.rgb = RGBColor(0, 255, 0)  # 标签颜色

plot = chart.plots[0]  # 取图表中第一个plot
plot.has_data_labels = True  # 是否显示数据标签

data_labels = plot.data_labels  # 数据标签控制类

data_labels.font.size = Pt(13)  # 字体大小
data_labels.font.color.rgb = RGBColor(0, 0, 0)  # 字体颜色
data_labels.position = XL_DATA_LABEL_POSITION.OUTSIDE_END  # 字体位置

prs.save('test.pptx')