图表数据标签
Contents
[
Hide
]
图表上的数据标签显示有关图表数据系列或单个数据点的详细信息。它们使读者能够快速识别数据系列，并且使图表更易于理解。
设置图表数据标签中的数据精度
此Python代码向您展示了如何设置图表数据标签中的数据精度：
import aspose.slides.charts as charts
import aspose.slides as slides
with slides.Presentation() as pres:
chart = pres.slides[0].shapes.add_chart(charts.ChartType.LINE, 50, 50, 450, 300)
chart.has_data_table = True
chart.chart_data.series[0].number_format_of_values = "#,##0.00"
pres.save("PrecisionOfDatalabels_out.pptx", slides.export.SaveFormat.PPTX)
将百分比作为标签显示
Aspose.Slides for Python via .NET允许您在显示的图表上设置百分比标签。此Python代码演示了该操作：
import aspose.slides.charts as charts
import aspose.slides as slides
# 创建Presentation类的实例
with slides.Presentation() as presentation:
slide = presentation.slides[0]
chart = slide.shapes.add_chart(charts.ChartType.STACKED_COLUMN, 20, 20, 400, 400)
series = chart.chart_data.series[0]
total_for_Cat = [0]*len(chart.chart_data.categories)
for k in range(len(chart.chart_data.categories)):
cat = chart.chart_data.categories[k]
for i in range(len(chart.chart_data.series)):
total_for_Cat[k] += chart.chart_data.series[i].data_points[k].value.data
dataPontPercent = 0
for x in range(len(chart.chart_data.series)):
series = chart.chart_data.series[x]
series.labels.default_data_label_format.show_legend_key = False
for j in range(len(series.data_points)):
lbl = series.data_points[j].label
dataPontPercent = series.data_points[j].value.data / total_for_Cat[j] * 100
port = slides.Portion()
port.text = "{0:.2f} %".format(dataPontPercent)
port.portion_format.font_height = 8
lbl.text_frame_for_overriding.text = ""
para = lbl.text_frame_for_overriding.paragraphs[0]
para.portions.add(port)
lbl.data_label_format.show_series_name = False
lbl.data_label_format.show_percentage = False
lbl.data_label_format.show_legend_key = False
lbl.data_label_format.show_category_name = False
lbl.data_label_format.show_bubble_size = False
# 保存包含图表的演示文稿
presentation.save("DisplayPercentageAsLabels_out.pptx", slides.export.SaveFormat.PPTX)
设置带有图表数据标签的百分号
此Python代码向您展示如何为图表数据标签设置百分号：
import aspose.slides.charts as charts
import aspose.slides as slides
import aspose.pydrawing as draw
# 创建Presentation类的实例
with slides.Presentation() as presentation:
# 通过索引获取幻灯片的引用
slide = presentation.slides[0]
# 在幻灯片上创建PercentsStackedColumn图表
chart = slide.shapes.add_chart(charts.ChartType.PERCENTS_STACKED_COLUMN, 20, 20, 500, 400)
# 将NumberFormatLinkedToSource设置为false
chart.axes.vertical_axis.is_number_format_linked_to_source = False
chart.axes.vertical_axis.number_format = "0.00%"
chart.chart_data.series.clear()
defaultWorksheetIndex = 0
# 获取图表数据工作表
workbook = chart.chart_data.chart_data_workbook
# 添加新系列
series = chart.chart_data.series.add(workbook.get_cell(defaultWorksheetIndex, 0, 1, "Reds"), chart.type)
series.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 1, 1, 0.30))
series.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 2, 1, 0.50))
series.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 3, 1, 0.80))
series.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 4, 1, 0.65))
# 设置系列的填充颜色
series.format.fill.fill_type = slides.FillType.SOLID
series.format.fill.solid_fill_color.color = draw.Color.red
# 设置LabelFormat属性
series.labels.default_data_label_format.show_value = True
series.labels.default_data_label_format.is_number_format_linked_to_source = False
series.labels.default_data_label_format.number_format = "0.0%"
series.labels.default_data_label_format.text_format.portion_format.font_height = 10
series.labels.default_data_label_format.text_format.portion_format.fill_format.fill_type = slides.FillType.SOLID
series.labels.default_data_label_format.text_format.portion_format.fill_format.solid_fill_color.color = draw.Color.white
series.labels.default_data_label_format.show_value = True
# 添加新系列
series2 = chart.chart_data.series.add(workbook.get_cell(defaultWorksheetIndex, 0, 2, "Blues"), chart.type)
series2.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 1, 2, 0.70))
series2.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 2, 2, 0.50))
series2.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 3, 2, 0.20))
series2.data_points.add_data_point_for_bar_series(workbook.get_cell(defaultWorksheetIndex, 4, 2, 0.35))
# 设置填充类型和颜色
series2.format.fill.fill_type = slides.FillType.SOLID
series2.format.fill.solid_fill_color.color = draw.Color.blue
series2.labels.default_data_label_format.show_value = True
series2.labels.default_data_label_format.is_number_format_linked_to_source = False
series2.labels.default_data_label_format.number_format = "0.0%"
series2.labels.default_data_label_format.text_format.portion_format.font_height = 10
series2.labels.default_data_label_format.text_format.portion_format.fill_format.fill_type = slides.FillType.SOLID
series2.labels.default_data_label_format.text_format.portion_format.fill_format.solid_fill_color.color = draw.Color.white
# 将演示文稿写入磁盘
presentation.save("SetDatalabelsPercentageSign_out.pptx", slides.export.SaveFormat.PPTX)
设置与轴的标签距离
此Python代码向您展示如何设置与类别轴的标签距离：
import aspose.slides.charts as charts
import aspose.slides as slides
# 创建Presentation类的实例
with slides.Presentation() as presentation:
# 获取幻灯片的引用
sld = presentation.slides[0]
# 在幻灯片上创建图表
ch = sld.shapes.add_chart(charts.ChartType.CLUSTERED_COLUMN, 20, 20, 500, 300)
# 设置与轴的标签距离
ch.axes.horizontal_axis.label_offset = 500
# 将演示文稿写入磁盘
presentation.save("SetCategoryAxisLabelDistance_out.pptx", slides.export.SaveFormat.PPTX)
调整标签位置
当您创建一个不依赖于任何轴的图表（例如饼图）时，图表的数据标签可能会过于接近边缘。在这种情况下，您必须调整数据标签的位置，以便清晰地显示引导线。
此Python代码向您展示如何在饼图上调整标签位置：
import aspose.slides as slides
with slides.Presentation() as pres:
chart = pres.slides[0].shapes.add_chart(slides.charts.ChartType.PIE, 50, 50, 200, 200)
series = chart.chart_data.series
label = series[0].labels[0]
label.data_label_format.show_value = True
label.data_label_format.position = slides.charts.LegendDataLabelPosition.OUTSIDE_END
label.x = 0.71
label.y = 0.04
pres.save("pres.pptx", slides.export.SaveFormat.PPTX)
