Module: Libxlsxwriter::ChartSeriesWrappers

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

Overview

(Not documented)

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)


3194
3195
3196
# File 'lib/fast_excel/binding.rb', line 3194

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)


3230
3231
3232
# File 'lib/fast_excel/binding.rb', line 3230

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

#set_invert_if_negativenil

Returns:

  • (nil)


3235
3236
3237
# File 'lib/fast_excel/binding.rb', line 3235

def set_invert_if_negative()
  Libxlsxwriter.chart_series_set_invert_if_negative(self)
end

#set_labelsnil

Returns:

  • (nil)


3288
3289
3290
# File 'lib/fast_excel/binding.rb', line 3288

def set_labels()
  Libxlsxwriter.chart_series_set_labels(self)
end

#set_labels_font(font) ⇒ nil

Parameters:

Returns:

  • (nil)


3335
3336
3337
# File 'lib/fast_excel/binding.rb', line 3335

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

#set_labels_leader_linenil

Returns:

  • (nil)


3313
3314
3315
# File 'lib/fast_excel/binding.rb', line 3313

def set_labels_leader_line()
  Libxlsxwriter.chart_series_set_labels_leader_line(self)
end

#set_labels_legendnil

Returns:

  • (nil)


3318
3319
3320
# File 'lib/fast_excel/binding.rb', line 3318

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)


3329
3330
3331
# File 'lib/fast_excel/binding.rb', line 3329

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)


3296
3297
3298
# File 'lib/fast_excel/binding.rb', line 3296

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)


3323
3324
3325
# File 'lib/fast_excel/binding.rb', line 3323

def set_labels_percentage()
  Libxlsxwriter.chart_series_set_labels_percentage(self)
end

#set_labels_position(position) ⇒ nil

Parameters:

  • position (Integer)

Returns:

  • (nil)


3308
3309
3310
# File 'lib/fast_excel/binding.rb', line 3308

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

#set_labels_separator(separator) ⇒ nil

Parameters:

  • separator (Integer)

Returns:

  • (nil)


3302
3303
3304
# File 'lib/fast_excel/binding.rb', line 3302

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

#set_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


3224
3225
3226
# File 'lib/fast_excel/binding.rb', line 3224

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

#set_marker_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


3265
3266
3267
# File 'lib/fast_excel/binding.rb', line 3265

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

#set_marker_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


3259
3260
3261
# File 'lib/fast_excel/binding.rb', line 3259

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

#set_marker_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


3271
3272
3273
# File 'lib/fast_excel/binding.rb', line 3271

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

#set_marker_size(size) ⇒ nil

Parameters:

  • size (Integer)

Returns:

  • (nil)


3253
3254
3255
# File 'lib/fast_excel/binding.rb', line 3253

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

#set_marker_type(type) ⇒ nil

Parameters:

  • type (Integer)

Returns:

  • (nil)


3247
3248
3249
# File 'lib/fast_excel/binding.rb', line 3247

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

#set_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


3210
3211
3212
# File 'lib/fast_excel/binding.rb', line 3210

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)


3218
3219
3220
# File 'lib/fast_excel/binding.rb', line 3218

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)


3241
3242
3243
# File 'lib/fast_excel/binding.rb', line 3241

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

#set_points(points) ⇒ Symbol from _enum_error_

Parameters:

Returns:



3277
3278
3279
# File 'lib/fast_excel/binding.rb', line 3277

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

#set_smooth(smooth) ⇒ nil

Parameters:

  • smooth (Integer)

Returns:

  • (nil)


3283
3284
3285
# File 'lib/fast_excel/binding.rb', line 3283

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

#set_trendline(type, value) ⇒ nil

Parameters:

  • type (Integer)
  • value (Integer)

Returns:

  • (nil)


3342
3343
3344
# File 'lib/fast_excel/binding.rb', line 3342

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

#set_trendline_equationnil

Returns:

  • (nil)


3354
3355
3356
# File 'lib/fast_excel/binding.rb', line 3354

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)


3349
3350
3351
# File 'lib/fast_excel/binding.rb', line 3349

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)


3365
3366
3367
# File 'lib/fast_excel/binding.rb', line 3365

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

#set_trendline_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


3377
3378
3379
# File 'lib/fast_excel/binding.rb', line 3377

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

#set_trendline_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


3371
3372
3373
# File 'lib/fast_excel/binding.rb', line 3371

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

#set_trendline_r_squarednil

Returns:

  • (nil)


3359
3360
3361
# File 'lib/fast_excel/binding.rb', line 3359

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)


3204
3205
3206
# File 'lib/fast_excel/binding.rb', line 3204

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