Class: Writexlsx::Chart::Column

Inherits:
Writexlsx::Chart show all
Includes:
Utility
Defined in:
lib/write_xlsx/chart/column.rb

Overview

The Column chart module also supports the following sub-types:

stacked
percent_stacked

These can be specified at creation time via the add_chart() Worksheet method:

chart = workbook.add_chart( :type => 'column', :subtype => 'stacked' )

Constant Summary

Constants included from Utility

Utility::COL_MAX, Utility::ROW_MAX, Utility::SHEETNAME_MAX, Utility::STR_MAX

Instance Attribute Summary

Attributes inherited from Writexlsx::Chart

#embedded, #formula_data, #formula_ids, #id, #index, #name, #palette, #protection

Instance Method Summary collapse

Methods included from Utility

#absolute_char, #check_dimensions, #check_dimensions_and_update_max_min_values, #check_parameter, #convert_date_time, delete_files, #ptrue?, #put_deprecate_message, #row_col_notation, #store_col_max_min_values, #store_row_max_min_values, #substitute_cellref, #underline_attributes, #write_color, #xl_cell_to_rowcol, #xl_col_to_name, #xl_range, #xl_range_formula, #xl_rowcol_to_cell, #xml_str

Methods inherited from Writexlsx::Chart

#add_series, #assemble_xml_file, factory, #set_chartarea, #set_embedded_config_data, #set_legend, #set_plotarea, #set_style, #set_title, #set_x2_axis, #set_x_axis, #set_xml_writer, #set_y2_axis, #set_y_axis, #show_blanks_as, #show_hidden_data, #write_bar_chart

Constructor Details

#initialize(subtype) ⇒ Column

Returns a new instance of Column.



31
32
33
34
35
36
37
38
39
40
41
42
 
# File 'lib/write_xlsx/chart/column.rb', line 31

def initialize(subtype)
  super(subtype)
  @subtype = subtype || 'clustered'
  @horiz_val_axis = 0

  # Override and reset the default axis values.
  if @subtype == 'percent_stacked'
    @y_axis[:_defaults][:num_format] = '0%'
  end

  set_y_axis
end

Instance Method Details

#write_bar_dir ⇒ Object

Write the <c:barDir> element.



55
56
57
58
59
60
61
 
# File 'lib/write_xlsx/chart/column.rb', line 55

def write_bar_dir
  val  = 'col'

  attributes = ['val', val]

  @writer.empty_tag('c:barDir', attributes)
end

#write_chart_type(params) ⇒ Object

Override the virtual superclass method with a chart specific method.



47
48
49
50
 
# File 'lib/write_xlsx/chart/column.rb', line 47

def write_chart_type(params)
  # Write the c:barChart element.
  write_bar_chart(params)
end