class Aio::Base::Toolkit::ExcelOffice::Chart

图表

Constants

BarClustered
ChartStyle
ChartType
ColumnClustered

图形类型

ColumnStacked
DataLabelsShowLabel

标签数据

DataLabelsShowLabelAndPercent
DataLabelsShowPercent
DataLabelsShowValue
Doughnut
HasTitle
Line
Pie
Position
ShowSeriesName
Text

Public Class Methods

new(active) click to toggle source
# File lib/aio/base/toolkit/excel_office.rb, line 356
def initialize(active)
        @chart = active
end

Public Instance Methods

axes_x=(name) click to toggle source

设置X轴名称, 只用于条形图

# File lib/aio/base/toolkit/excel_office.rb, line 381
def axes_x=(name)
        @chart.Axes(1,1).HasTitle = true
        @chart.Axes(1,1).AxisTitle.Characters.Text = name
end
axes_y=(name) click to toggle source

设置Y轴名称, 只用于条形图

# File lib/aio/base/toolkit/excel_office.rb, line 387
def axes_y=(name)
        @chart.Axes(2,1).HasTitle = true
        @chart.Axes(2,1).AxisTitle.Characters.Text = name
end
chart_work() click to toggle source
# File lib/aio/base/toolkit/excel_office.rb, line 360
def chart_work
        @chart
end
data_label(type=DataLabelsShowLabelAndPercent) click to toggle source

添加饼图的百分比

# File lib/aio/base/toolkit/excel_office.rb, line 402
def data_label(type=DataLabelsShowLabelAndPercent)

        # 应用标签选项
        @chart.ApplyDataLabels(type)

        # 取消标签选项的系列名称
        now = @chart.SeriesCollection(1).DataLabels
        now.ShowSeriesName = false

        # 将图例放到右边
        now = @chart.Legend
        now.Position = -4152
end
source=(range) click to toggle source

这是原数据地址, 按列生成数据

# File lib/aio/base/toolkit/excel_office.rb, line 371
def source=(range)
        @chart.SetSourceData(range, 2)
end
style=(int) click to toggle source

修改样式 通过录制宏可以查看样式编号 条形图中203 比较好看 饼图中 251, 254 比较好看

# File lib/aio/base/toolkit/excel_office.rb, line 396
def style=(int)
        @chart.ChartStyle = int
        data_label
end
title=(name) click to toggle source

修改标题

# File lib/aio/base/toolkit/excel_office.rb, line 365
def title=(name)
        @chart.HasTitle = true
        @chart.ChartTitle.Characters.Text = name
end
type=(c_type) click to toggle source

更改图形类型

# File lib/aio/base/toolkit/excel_office.rb, line 376
def type=(c_type)
        @chart.ChartType = c_type
end