Skip to content

Instantly share code, notes, and snippets.

@preetika-subramaniam

preetika-subramaniam/axlsx_bar_graph.rb

Forked from manusajith/axlsx_bar_graph.rb
Created January 27, 2018 05:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save preetika-subramaniam/74632f5a97ebab1c60e93452aef91cce to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save preetika-subramaniam/74632f5a97ebab1c60e93452aef91cce to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @manusajith manusajith created this gist Mar 16, 2013.
    11 changes: 11 additions & 0 deletions axlsx_bar_graph.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    require 'axlsx'
    Axlsx::Package.new do |p|
    p.workbook.add_worksheet(:name => "Pie Chart") do |sheet|
    sheet.add_row ["Simple Pie Chart"]
    %w(first second third).each { |label| sheet.add_row [label, rand(24)+1] }
    sheet.add_chart(Axlsx::Bar3DChart, :start_at => "A6", :end_at => "F20", :barDir => :col) do |chart|
    chart.add_series :data => sheet["B2:B4"], :labels => sheet["A2:A4"], :colors => ['FF0000', '00FF00', '0000FF']
    end
    end
    p.serialize('simple.xlsx')
    end