summaryrefslogtreecommitdiffhomepage
path: root/examples/basic_charts.rb
diff options
context:
space:
mode:
authorZsolt Kozaroczy <[email protected]>2020-09-11 00:36:29 +0200
committerGitHub <[email protected]>2020-09-11 00:36:29 +0200
commit282eec44ef01746ee25931fa6cd287ad083fd40b (patch)
tree14504bf429ca264812679ca971c1592853d3f762 /examples/basic_charts.rb
parent317e8244e4d17c394c1e181f86df3974623fb865 (diff)
downloadcaxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.tar.gz
caxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.zip
Restructure examples folder (#47)
Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files.
Diffstat (limited to 'examples/basic_charts.rb')
-rw-r--r--examples/basic_charts.rb58
1 files changed, 0 insertions, 58 deletions
diff --git a/examples/basic_charts.rb b/examples/basic_charts.rb
deleted file mode 100644
index 097af57e..00000000
--- a/examples/basic_charts.rb
+++ /dev/null
@@ -1,58 +0,0 @@
-$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
-require 'axlsx'
-p = Axlsx::Package.new
-wb = p.workbook
-
-# Pie Chart
-wb.add_worksheet(:name => "Pie Chart") do |sheet|
- sheet.add_row ["First", "Second", "Third", "Fourth"]
- sheet.add_row [1, 2, 3, 4]
- sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=> 'dark corner here') do |chart|
- chart.add_series :data => sheet["A2:D2"], :labels => sheet["A1:D1"]
- chart.d_lbls.show_val = true
- chart.d_lbls.show_percent = true
- chart.d_lbls.d_lbl_pos = :outEnd
- chart.d_lbls.show_leader_lines = true
- end
-end
-
-# line chart
- wb.add_worksheet(:name => "Line Chart") do |sheet|
- sheet.add_row ['1', '2', '3', '4']
- sheet.add_row [1, 2, 3, '=sum(A2:C2)']
- sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [5, 15], :title => "Chart") do |chart|
- chart.add_series :data => sheet["A2:D2"], :labels => sheet["A1:D1"], :title => 'bob'
- chart.d_lbls.show_val = true
- chart.d_lbls.show_cat_name = true
- chart.catAxis.tick_lbl_pos = :none
-
- end
- end
-
-# bar chart
- wb.add_worksheet(:name => "Bar Chart") do |sheet|
- sheet.add_row ["A Simple Bar Chart"]
- sheet.add_row ["First", "Second", "Third"]
- sheet.add_row [1, 2, 3]
- sheet.add_chart(Axlsx::Bar3DChart, :start_at => "A4", :end_at => "F17") do |chart|
- chart.add_series :data => sheet["A3:C3"], :labels => sheet["A2:C2"], :title => sheet["A1"]
- chart.valAxis.label_rotation = -45
- chart.catAxis.label_rotation = 45
- chart.d_lbls.d_lbl_pos = :outEnd
- chart.d_lbls.show_val = true
-
- chart.catAxis.tick_lbl_pos = :none
- end
- end
-
-# specifying colors and title
-wb.add_worksheet(:name => "Colored Pie Chart") do |sheet|
- sheet.add_row ["First", "Second", "Third", "Fourth"]
- sheet.add_row [1, 2, 3, "=PRODUCT(A2:C2)"]
- sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title => "example 3: Pie Chart") do |chart|
- chart.add_series :data => sheet["A2:D2"], :labels => ["A1:D1"], :colors => ['FF0000', '00FF00', '0000FF']
- end
-end
-
-p.serialize('basic_charts.xlsx')
-