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)

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

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)

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

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

#set_invert_if_negativenil

Returns:

  • (nil)

1119
1120
1121
# File 'lib/fast_excel/binding/chart.rb', line 1119

def set_invert_if_negative()
  Libxlsxwriter.chart_series_set_invert_if_negative(self)
end

#set_labelsnil

Returns:

  • (nil)

1172
1173
1174
# File 'lib/fast_excel/binding/chart.rb', line 1172

def set_labels()
  Libxlsxwriter.chart_series_set_labels(self)
end

#set_labels_font(font) ⇒ nil

Parameters:

Returns:

  • (nil)

1219
1220
1221
# File 'lib/fast_excel/binding/chart.rb', line 1219

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

#set_labels_leader_linenil

Returns:

  • (nil)

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

def set_labels_leader_line()
  Libxlsxwriter.chart_series_set_labels_leader_line(self)
end

#set_labels_legendnil

Returns:

  • (nil)

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

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)

1213
1214
1215
# File 'lib/fast_excel/binding/chart.rb', line 1213

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)

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

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)

1207
1208
1209
# File 'lib/fast_excel/binding/chart.rb', line 1207

def set_labels_percentage()
  Libxlsxwriter.chart_series_set_labels_percentage(self)
end

#set_labels_position(position) ⇒ nil

Parameters:

  • position (Integer)

Returns:

  • (nil)

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

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

#set_labels_separator(separator) ⇒ nil

Parameters:

  • separator (Integer)

Returns:

  • (nil)

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

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

#set_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)

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

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

#set_marker_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)

1149
1150
1151
# File 'lib/fast_excel/binding/chart.rb', line 1149

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

#set_marker_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)

1143
1144
1145
# File 'lib/fast_excel/binding/chart.rb', line 1143

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

#set_marker_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)

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

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

#set_marker_size(size) ⇒ nil

Parameters:

  • size (Integer)

Returns:

  • (nil)

1137
1138
1139
# File 'lib/fast_excel/binding/chart.rb', line 1137

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

#set_marker_type(type) ⇒ nil

Parameters:

  • type (Integer)

Returns:

  • (nil)

1131
1132
1133
# File 'lib/fast_excel/binding/chart.rb', line 1131

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

#set_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)

1094
1095
1096
# File 'lib/fast_excel/binding/chart.rb', line 1094

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)

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

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)

1125
1126
1127
# File 'lib/fast_excel/binding/chart.rb', line 1125

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

#set_points(points) ⇒ Symbol from _enum_error_

Parameters:

Returns:


1161
1162
1163
# File 'lib/fast_excel/binding/chart.rb', line 1161

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

#set_smooth(smooth) ⇒ nil

Parameters:

  • smooth (Integer)

Returns:

  • (nil)

1167
1168
1169
# File 'lib/fast_excel/binding/chart.rb', line 1167

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

#set_trendline(type, value) ⇒ nil

Parameters:

  • type (Integer)
  • value (Integer)

Returns:

  • (nil)

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

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

#set_trendline_equationnil

Returns:

  • (nil)

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

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)

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

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)

1249
1250
1251
# File 'lib/fast_excel/binding/chart.rb', line 1249

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

#set_trendline_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)

1261
1262
1263
# File 'lib/fast_excel/binding/chart.rb', line 1261

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

#set_trendline_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)

1255
1256
1257
# File 'lib/fast_excel/binding/chart.rb', line 1255

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

#set_trendline_r_squarednil

Returns:

  • (nil)

1243
1244
1245
# File 'lib/fast_excel/binding/chart.rb', line 1243

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)

1088
1089
1090
# File 'lib/fast_excel/binding/chart.rb', line 1088

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