From 705b92c0764452cfa8a2b8e4130cadb0bd83e798 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Mon, 4 Jun 2012 13:18:36 +0900 Subject: another example --- examples/pie_chart.rb | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 examples/pie_chart.rb (limited to 'examples') 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') +## -- cgit v1.2.3