Class: Axlsx::Chart

Inherits:
Object
  • Object
show all
Includes:
OptionsParser
Defined in:
lib/axlsx/drawing/chart.rb

Overview

Note:

Worksheet#add_chart is the recommended way to create charts for your worksheets.

A Chart is the superclass for specific charts

See Also:

  • for examples

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(frame, options = {}) {|_self| ... } ⇒ Chart

Creates a new chart object

Options Hash (options):

  • title (Cell, String)
  • show_legend (Boolean)
  • legend_position (Symbol)
  • start_at (Array|String|Cell)

    The X, Y coordinates defining the top left corner of the chart.

  • end_at (Array|String|Cell)

    The X, Y coordinates defining the bottom right corner of the chart.

Yields:

  • (_self)

Yield Parameters:

  • _self (Axlsx::Chart)

    the object that the method was called on



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
# File 'lib/axlsx/drawing/chart.rb', line 17

def initialize(frame, options={})
  @style = 18
  @view_3D = nil
  @graphic_frame=frame
  @graphic_frame.anchor.drawing.worksheet.workbook.charts << self
  @series = SimpleTypedList.new Series
  @show_legend = true
  @legend_position = :r
  @display_blanks_as = :gap
  @series_type = Series
  @title = Title.new
  @bg_color = nil
  parse_options options
  start_at(*options[:start_at]) if options[:start_at]
  end_at(*options[:end_at]) if options[:end_at]
  yield self if block_given?
end

Instance Attribute Details

#bg_colorString

Background color for the chart



99
100
101
# File 'lib/axlsx/drawing/chart.rb', line 99

def bg_color
  @bg_color
end

#display_blanks_asSymbol

How to display blank values Options are * gap: Display nothing * span: Not sure what this does * zero: Display as if the value were zero, not blank Default :gap (although this really should vary by chart type and grouping)



95
96
97
# File 'lib/axlsx/drawing/chart.rb', line 95

def display_blanks_as
  @display_blanks_as
end

#graphic_frameGraphicFrame (readonly)

A reference to the graphic frame that owns this chart



41
42
43
# File 'lib/axlsx/drawing/chart.rb', line 41

def graphic_frame
  @graphic_frame
end

#legend_positionSymbol

Note:

The following are allowed :b :l :r :t :tr

Set the location of the chart's legend



86
87
88
# File 'lib/axlsx/drawing/chart.rb', line 86

def legend_position
  @legend_position
end

#seriesSimpleTypedList (readonly)

A collection of series objects that are applied to the chart



45
46
47
# File 'lib/axlsx/drawing/chart.rb', line 45

def series
  @series
end

#series_typeSeries (readonly)

The type of series to use for this chart.



49
50
51
# File 'lib/axlsx/drawing/chart.rb', line 49

def series_type
  @series_type
end

#show_legendBoolean

Show the legend in the chart



75
76
77
# File 'lib/axlsx/drawing/chart.rb', line 75

def show_legend
  @show_legend
end

#styleInteger

The style for the chart. see ECMA Part 1 ยง21.2.2.196



71
72
73
# File 'lib/axlsx/drawing/chart.rb', line 71

def style
  @style
end

#titleTitle

The title object for the chart.



66
67
68
# File 'lib/axlsx/drawing/chart.rb', line 66

def title
  @title
end

#vary_colorsBoolean

Indicates that colors should be varied by datum



58
59
60
# File 'lib/axlsx/drawing/chart.rb', line 58

def vary_colors
  @vary_colors
end

#view_3DObject Also known as: view3D

The 3D view properties for the chart



36
37
38
# File 'lib/axlsx/drawing/chart.rb', line 36

def view_3D
  @view_3D
end

Instance Method Details

#add_series(options = {}) ⇒ Series

Adds a new series to the chart's series collection.

See Also:



165
166
167
168
# File 'lib/axlsx/drawing/chart.rb', line 165

def add_series(options={})
  @series_type.new(self, options)
  @series.last
end

#d_lblsObject

TODO data labels!



52
53
54
# File 'lib/axlsx/drawing/chart.rb', line 52

def d_lbls
  @d_lbls ||= DLbls.new(self.class)
end

#end_at(x = 10, y = 10) ⇒ Marker

This is a short cut method to set the end anchor position If you need finer granularity in positioning use graphic_frame.anchor.to.colOff / rowOff

See Also:

  • start_at


259
260
261
# File 'lib/axlsx/drawing/chart.rb', line 259

def end_at(x=10, y=10)
  @graphic_frame.anchor.end_at(x, y)
end

#fromObject

Note:

This will be disconinued in version 2.0.0. please use the start_at method

backwards compatibility to allow chart.to and chart.from access to anchor markers



158
159
160
# File 'lib/axlsx/drawing/chart.rb', line 158

def from
  @graphic_frame.anchor.from
end

#indexInteger

The index of this chart in the workbooks charts collection



109
110
111
# File 'lib/axlsx/drawing/chart.rb', line 109

def index
  @graphic_frame.anchor.drawing.worksheet.workbook.charts.index(self)
end

#pnString

The part name for this chart



115
116
117
# File 'lib/axlsx/drawing/chart.rb', line 115

def pn
  "#{CHART_PN % (index+1)}"
end

#relationshipRelationship

The relationship object for this chart.



103
104
105
# File 'lib/axlsx/drawing/chart.rb', line 103

def relationship
  Relationship.new(self, CHART_R, "../#{pn}")
end

#start_at(x = 0, y = 0) ⇒ Marker

This is a short cut method to set the anchor start marker position If you need finer granularity in positioning use

This helper method acceps a fairly wide range of inputs exampled below

reference or cell to use in setting the start marker position.

Examples:


start_at 0, 5 # The anchor start marker is set to 6th row of
the first column

start_at [0, 5] # The anchor start marker is set to start on the 6th row
of the first column

start_at "C1" # The anchor start marker is set to start on the first row
of the third column

start_at sheet.rows.first.cells.last # The anchor start
marker is set to the location of a specific cell.


248
249
250
# File 'lib/axlsx/drawing/chart.rb', line 248

def start_at(x=0, y=0)
  @graphic_frame.anchor.start_at(x, y)
end

#toObject

Note:

This will be disconinued in version 2.0.0. Please use the end_at method

backwards compatibility to allow chart.to and chart.from access to anchor markers



152
153
154
# File 'lib/axlsx/drawing/chart.rb', line 152

def to
  @graphic_frame.anchor.to
end

#to_xml_string(str = '') ⇒ String

Serializes the object



179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
# File 'lib/axlsx/drawing/chart.rb', line 179

def to_xml_string(str = '')
  str << '<?xml version="1.0" encoding="UTF-8"?>'
  str << ('<c:chartSpace xmlns:c="' << XML_NS_C << '" xmlns:a="' << XML_NS_A << '" xmlns:r="' << XML_NS_R << '">')
  str << ('<c:date1904 val="' << Axlsx::Workbook.date1904.to_s << '"/>')
  str << ('<c:style val="' << style.to_s << '"/>')
  str << '<c:chart>'
  @title.to_xml_string str
  str << ('<c:autoTitleDeleted val="' << (@title == nil).to_s << '"/>')
  @view_3D.to_xml_string(str) if @view_3D
  str << '<c:floor><c:thickness val="0"/></c:floor>'
  str << '<c:sideWall><c:thickness val="0"/></c:sideWall>'
  str << '<c:backWall><c:thickness val="0"/></c:backWall>'
  str << '<c:plotArea>'
  str << '<c:layout/>'
  yield if block_given?
  str << '</c:plotArea>'
  if @show_legend
    str << '<c:legend>'
    str << ('<c:legendPos val="' << @legend_position.to_s << '"/>')
    str << '<c:layout/>'
    str << '<c:overlay val="0"/>'
    str << '</c:legend>'
  end
  str << '<c:plotVisOnly val="1"/>'
  str << ('<c:dispBlanksAs val="' << display_blanks_as.to_s << '"/>')
  str << '<c:showDLblsOverMax val="1"/>'
  str << '</c:chart>'
  if bg_color
    str << '<c:spPr>'
    str << '<a:solidFill>'
    str << '<a:srgbClr val="' << bg_color << '"/>'
    str << '</a:solidFill>'
    str << '<a:ln>'
    str << '<a:noFill/>'
    str << '</a:ln>'
    str << '</c:spPr>'
  end
  str << '<c:printSettings>'
  str << '<c:headerFooter/>'
  str << '<c:pageMargins b="1.0" l="0.75" r="0.75" t="1.0" header="0.5" footer="0.5"/>'
  str << '<c:pageSetup/>'
  str << '</c:printSettings>'
  str << '</c:chartSpace>'
end