class 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/excel_office.rb, line 353 def initialize(active) @chart = active end
Public Instance Methods
axes_x=(name)
click to toggle source
设置X轴名称, 只用于条形图
# File lib/excel_office.rb, line 378 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/excel_office.rb, line 384 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/excel_office.rb, line 357 def chart_work @chart end
data_label(type=DataLabelsShowLabelAndPercent)
click to toggle source
添加饼图的百分比
# File lib/excel_office.rb, line 399 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/excel_office.rb, line 368 def source=(range) @chart.SetSourceData(range, 2) end
style=(int)
click to toggle source
修改样式 通过录制宏可以查看样式编号 条形图中203 比较好看 饼图中 251, 254 比较好看
# File lib/excel_office.rb, line 393 def style=(int) @chart.ChartStyle = int data_label end
title=(name)
click to toggle source
修改标题
# File lib/excel_office.rb, line 362 def title=(name) @chart.HasTitle = true @chart.ChartTitle.Characters.Text = name end
type=(c_type)
click to toggle source
更改图形类型
# File lib/excel_office.rb, line 373 def type=(c_type) @chart.ChartType = c_type end