Module: Libxlsxwriter::ChartSeriesWrappers

Included in:
ChartSeries
Defined in:
lib/fast_excel/binding/chart.rb

Overview

Fields:

:categories

(SeriesRange)

:values

(SeriesRange)

:title

(ChartTitle)

:line

(ChartLine)

:fill

(ChartFill)

:pattern

(ChartPattern)

:marker

(ChartMarker)

:points

(ChartPoint)

:point_count

(Integer)

:smooth

(Integer)

:invert_if_negative

(Integer)

:has_labels

(Integer) Data label parameters.

:show_labels_value

(Integer)

:show_labels_category

(Integer)

:show_labels_name

(Integer)

:show_labels_leader

(Integer)

:show_labels_legend

(Integer)

:show_labels_percent

(Integer)

:label_position

(Integer)

:label_separator

(Integer)

:default_label_position

(Integer)

:label_num_format

(String)

:label_font

(ChartFont)

:x_error_bars

(SeriesErrorBars)

:y_error_bars

(SeriesErrorBars)

:has_trendline

(Integer)

:has_trendline_forecast

(Integer)

:has_trendline_equation

(Integer)

:has_trendline_r_squared

(Integer)

:has_trendline_intercept

(Integer)

:trendline_type

(Integer)

:trendline_value

(Integer)

:trendline_forward

(Float)

:trendline_backward

(Float)

:trendline_value_type

(Integer)

:trendline_name

(String)

:trendline_line

(ChartLine)

:trendline_intercept

(Float)

:list_pointers

(ChartSeriesListPointers)

Instance Method Summary collapse

Instance Method Details

#set_categories(sheetname, first_row, first_col, last_row, last_col) ⇒ nil

Parameters:

  • sheetname (String)
  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:

  • (nil)


1062
1063
1064
# File 'lib/fast_excel/binding/chart.rb', line 1062

def set_categories(sheetname, first_row, first_col, last_row, last_col)
  Libxlsxwriter.chart_series_set_categories(self, sheetname, first_row, first_col, last_row, last_col)
end

#set_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


1098
1099
1100
# File 'lib/fast_excel/binding/chart.rb', line 1098

def set_fill(fill)
  Libxlsxwriter.chart_series_set_fill(self, fill)
end

#set_invert_if_negativenil

Returns:

  • (nil)


1103
1104
1105
# File 'lib/fast_excel/binding/chart.rb', line 1103

def set_invert_if_negative()
  Libxlsxwriter.chart_series_set_invert_if_negative(self)
end

#set_labelsnil

Returns:

  • (nil)


1156
1157
1158
# File 'lib/fast_excel/binding/chart.rb', line 1156

def set_labels()
  Libxlsxwriter.chart_series_set_labels(self)
end

#set_labels_font(font) ⇒ nil

Parameters:

Returns:

  • (nil)


1203
1204
1205
# File 'lib/fast_excel/binding/chart.rb', line 1203

def set_labels_font(font)
  Libxlsxwriter.chart_series_set_labels_font(self, font)
end

#set_labels_leader_linenil

Returns:

  • (nil)


1181
1182
1183
# File 'lib/fast_excel/binding/chart.rb', line 1181

def set_labels_leader_line()
  Libxlsxwriter.chart_series_set_labels_leader_line(self)
end

#set_labels_legendnil

Returns:

  • (nil)


1186
1187
1188
# File 'lib/fast_excel/binding/chart.rb', line 1186

def set_labels_legend()
  Libxlsxwriter.chart_series_set_labels_legend(self)
end

#set_labels_num_format(num_format) ⇒ nil

Parameters:

  • num_format (String)

Returns:

  • (nil)


1197
1198
1199
# File 'lib/fast_excel/binding/chart.rb', line 1197

def set_labels_num_format(num_format)
  Libxlsxwriter.chart_series_set_labels_num_format(self, num_format)
end

#set_labels_options(show_name, show_category, show_value) ⇒ nil

Parameters:

  • show_name (Integer)
  • show_category (Integer)
  • show_value (Integer)

Returns:

  • (nil)


1164
1165
1166
# File 'lib/fast_excel/binding/chart.rb', line 1164

def set_labels_options(show_name, show_category, show_value)
  Libxlsxwriter.chart_series_set_labels_options(self, show_name, show_category, show_value)
end

#set_labels_percentagenil

Returns:

  • (nil)


1191
1192
1193
# File 'lib/fast_excel/binding/chart.rb', line 1191

def set_labels_percentage()
  Libxlsxwriter.chart_series_set_labels_percentage(self)
end

#set_labels_position(position) ⇒ nil

Parameters:

  • position (Integer)

Returns:

  • (nil)


1176
1177
1178
# File 'lib/fast_excel/binding/chart.rb', line 1176

def set_labels_position(position)
  Libxlsxwriter.chart_series_set_labels_position(self, position)
end

#set_labels_separator(separator) ⇒ nil

Parameters:

  • separator (Integer)

Returns:

  • (nil)


1170
1171
1172
# File 'lib/fast_excel/binding/chart.rb', line 1170

def set_labels_separator(separator)
  Libxlsxwriter.chart_series_set_labels_separator(self, separator)
end

#set_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1092
1093
1094
# File 'lib/fast_excel/binding/chart.rb', line 1092

def set_line(line)
  Libxlsxwriter.chart_series_set_line(self, line)
end

#set_marker_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


1133
1134
1135
# File 'lib/fast_excel/binding/chart.rb', line 1133

def set_marker_fill(fill)
  Libxlsxwriter.chart_series_set_marker_fill(self, fill)
end

#set_marker_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1127
1128
1129
# File 'lib/fast_excel/binding/chart.rb', line 1127

def set_marker_line(line)
  Libxlsxwriter.chart_series_set_marker_line(self, line)
end

#set_marker_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


1139
1140
1141
# File 'lib/fast_excel/binding/chart.rb', line 1139

def set_marker_pattern(pattern)
  Libxlsxwriter.chart_series_set_marker_pattern(self, pattern)
end

#set_marker_size(size) ⇒ nil

Parameters:

  • size (Integer)

Returns:

  • (nil)


1121
1122
1123
# File 'lib/fast_excel/binding/chart.rb', line 1121

def set_marker_size(size)
  Libxlsxwriter.chart_series_set_marker_size(self, size)
end

#set_marker_type(type) ⇒ nil

Parameters:

  • type (Integer)

Returns:

  • (nil)


1115
1116
1117
# File 'lib/fast_excel/binding/chart.rb', line 1115

def set_marker_type(type)
  Libxlsxwriter.chart_series_set_marker_type(self, type)
end

#set_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


1078
1079
1080
# File 'lib/fast_excel/binding/chart.rb', line 1078

def set_name(name)
  Libxlsxwriter.chart_series_set_name(self, name)
end

#set_name_range(sheetname, row, col) ⇒ nil

Parameters:

  • sheetname (String)
  • row (Integer)
  • col (Integer)

Returns:

  • (nil)


1086
1087
1088
# File 'lib/fast_excel/binding/chart.rb', line 1086

def set_name_range(sheetname, row, col)
  Libxlsxwriter.chart_series_set_name_range(self, sheetname, row, col)
end

#set_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


1109
1110
1111
# File 'lib/fast_excel/binding/chart.rb', line 1109

def set_pattern(pattern)
  Libxlsxwriter.chart_series_set_pattern(self, pattern)
end

#set_points(points) ⇒ Symbol from _enum_error_

Parameters:

Returns:



1145
1146
1147
# File 'lib/fast_excel/binding/chart.rb', line 1145

def set_points(points)
  Libxlsxwriter.chart_series_set_points(self, points)
end

#set_smooth(smooth) ⇒ nil

Parameters:

  • smooth (Integer)

Returns:

  • (nil)


1151
1152
1153
# File 'lib/fast_excel/binding/chart.rb', line 1151

def set_smooth(smooth)
  Libxlsxwriter.chart_series_set_smooth(self, smooth)
end

#set_trendline(type, value) ⇒ nil

Parameters:

  • type (Integer)
  • value (Integer)

Returns:

  • (nil)


1210
1211
1212
# File 'lib/fast_excel/binding/chart.rb', line 1210

def set_trendline(type, value)
  Libxlsxwriter.chart_series_set_trendline(self, type, value)
end

#set_trendline_equationnil

Returns:

  • (nil)


1222
1223
1224
# File 'lib/fast_excel/binding/chart.rb', line 1222

def set_trendline_equation()
  Libxlsxwriter.chart_series_set_trendline_equation(self)
end

#set_trendline_forecast(forward, backward) ⇒ nil

Parameters:

  • forward (Float)
  • backward (Float)

Returns:

  • (nil)


1217
1218
1219
# File 'lib/fast_excel/binding/chart.rb', line 1217

def set_trendline_forecast(forward, backward)
  Libxlsxwriter.chart_series_set_trendline_forecast(self, forward, backward)
end

#set_trendline_intercept(intercept) ⇒ nil

Parameters:

  • intercept (Float)

Returns:

  • (nil)


1233
1234
1235
# File 'lib/fast_excel/binding/chart.rb', line 1233

def set_trendline_intercept(intercept)
  Libxlsxwriter.chart_series_set_trendline_intercept(self, intercept)
end

#set_trendline_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1245
1246
1247
# File 'lib/fast_excel/binding/chart.rb', line 1245

def set_trendline_line(line)
  Libxlsxwriter.chart_series_set_trendline_line(self, line)
end

#set_trendline_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


1239
1240
1241
# File 'lib/fast_excel/binding/chart.rb', line 1239

def set_trendline_name(name)
  Libxlsxwriter.chart_series_set_trendline_name(self, name)
end

#set_trendline_r_squarednil

Returns:

  • (nil)


1227
1228
1229
# File 'lib/fast_excel/binding/chart.rb', line 1227

def set_trendline_r_squared()
  Libxlsxwriter.chart_series_set_trendline_r_squared(self)
end

#set_values(sheetname, first_row, first_col, last_row, last_col) ⇒ nil

Parameters:

  • sheetname (String)
  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:

  • (nil)


1072
1073
1074
# File 'lib/fast_excel/binding/chart.rb', line 1072

def set_values(sheetname, first_row, first_col, last_row, last_col)
  Libxlsxwriter.chart_series_set_values(self, sheetname, first_row, first_col, last_row, last_col)
end