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')
转载于:https://www.cnblogs.com/xiesongyou/p/8071986.html