pythonpptx_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')