summaryrefslogtreecommitdiffhomepage
path: root/examples
diff options
context:
space:
mode:
Diffstat (limited to 'examples')
-rw-r--r--examples/pie_chart.rb31
1 files changed, 31 insertions, 0 deletions
diff --git a/examples/pie_chart.rb b/examples/pie_chart.rb
new file mode 100644
index 00000000..8c261b31
--- /dev/null
+++ b/examples/pie_chart.rb
@@ -0,0 +1,31 @@
+$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
+require 'axlsx'
+p = Axlsx::Package.new
+wb = p.workbook
+##Generating A Pie Chart
+#```ruby
+wb.add_worksheet(:name => "Pie Chart") do |sheet|
+ sheet.add_row ["First", "Second", "Third", "Fourth"]
+ sheet.add_row [1, 2, 3, '=sum(A2:C2)']
+ sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title => "Chart") do |chart|
+ chart.add_series :data => sheet["A2:D2"], :labels => sheet["A1:D1"]
+ end
+end
+
+p.serialize('pie_chart.xlsx')
+
+
+#
+# Line Chart
+
+p = Axlsx::Package.new
+wb = p.workbook
+wb.add_worksheet(:name => "Line Chart") do |sheet|
+ sheet.add_row ['first', 'second', 'third', 'fourth']
+ 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'
+ end
+end
+p.serialize('line_chart.xlsx')
+##