1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
module Axlsx
# The Line3DChart is a three dimentional line chart (who would have guessed?) that you can add to your worksheet.
# @example Creating a chart
# # This example creates a line in a single sheet.
# require "rubygems" # if that is your preferred way to manage gems!
# require "axlsx"
#
# p = Axlsx::Package.new
# ws = p.workbook.add_worksheet
# ws.add_row :values => ["This is a chart with no data in the sheet"]
#
# chart = ws.add_chart(Axlsx::Line3DChart, :start_at=> [0,1], :end_at=>[0,6], :title=>"Most Popular Pets")
# chart.add_series :data => [1, 9, 10], :labels => ["Slimy Reptiles", "Fuzzy Bunnies", "Rottweiler"]
#
# @see Worksheet#add_chart
# @see Worksheet#add_row
# @see Chart#add_series
# @see Series
# @see Package#serialize
class Line3DChart < Chart
# the category axis
# @return [CatAxis]
attr_reader :catAxis
# the category axis
# @return [ValAxis]
attr_reader :valAxis
# the category axis
# @return [Axis]
attr_reader :serAxis
# space between bar or column clusters, as a percentage of the bar or column width.
# @return [String]
attr_reader :gapDepth
#grouping for a column, line, or area chart.
# must be one of [:percentStacked, :clustered, :standard, :stacked]
# @return [Symbol]
attr_reader :grouping
# validation regex for gap amount percent
GAP_AMOUNT_PERCENT = /0*(([0-9])|([1-9][0-9])|([1-4][0-9][0-9])|500)%/
# Creates a new line chart object
# @param [GraphicFrame] frame The workbook that owns this chart.
# @option options [Cell, String] title
# @option options [Boolean] show_legend
# @option options [Symbol] grouping
# @option options [String] gapDepth
# @option options [Integer] rotX
# @option options [String] hPercent
# @option options [Integer] rotY
# @option options [String] depthPercent
# @option options [Boolean] rAngAx
# @option options [Integer] perspective
# @see Chart
# @see View3D
def initialize(frame, options={})
@gapDepth = nil
@grouping = :standard
@catAxId = rand(8 ** 8)
@valAxId = rand(8 ** 8)
@serAxId = rand(8 ** 8)
@catAxis = CatAxis.new(@catAxId, @valAxId)
@valAxis = ValAxis.new(@valAxId, @catAxId)
@serAxis = SerAxis.new(@serAxId, @valAxId)
super(frame, options)
@series_type = LineSeries
@view3D = View3D.new({:perspective=>30}.merge(options))
end
# @see grouping
def grouping=(v)
RestrictionValidator.validate "Bar3DChart.grouping", [:percentStacked, :standard, :stacked], v
@grouping = v
end
# @see gapDepth
def gapDepth=(v)
RegexValidator.validate "Bar3DChart.gapWidth", GAP_AMOUNT_PERCENT, v
@gapDepth=(v)
end
# Serializes the bar chart
# @return [String]
def to_xml
super() do |xml|
xml.send('c:line3DChart') {
xml.send('c:grouping', :val=>grouping)
xml.send('c:varyColors', :val=>1)
@series.each { |ser| ser.to_xml(xml) }
xml.send('c:gapDepth', :val=>@gapDepth) unless @gapDepth.nil?
xml.send('c:axId', :val=>@catAxId)
xml.send('c:axId', :val=>@valAxId)
xml.send('c:axId', :val=>@serAxId)
}
@catAxis.to_xml(xml)
@valAxis.to_xml(xml)
@serAxis.to_xml(xml)
end
end
end
end
|
