diff options
| author | Sean Duckett <[email protected]> | 2012-03-27 14:42:02 -0500 |
|---|---|---|
| committer | Sean Duckett <[email protected]> | 2012-03-27 14:42:02 -0500 |
| commit | c4772258dc342a81cb08c825d7906d7313f5aff5 (patch) | |
| tree | 48225947e41892f84371ac73f826b4f1fd0a2908 /examples/example.rb | |
| parent | 004c6c5addff51a76d211e539cade5b77259cc4c (diff) | |
| parent | ec9d3b896a2b07cdcb8198c2227df8dac3b83cdb (diff) | |
| download | caxlsx-c4772258dc342a81cb08c825d7906d7313f5aff5.tar.gz caxlsx-c4772258dc342a81cb08c825d7906d7313f5aff5.zip | |
Merge branch 'master' of https://github.com/randym/axlsx
Diffstat (limited to 'examples/example.rb')
| -rw-r--r-- | examples/example.rb | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/examples/example.rb b/examples/example.rb index 2c0f5fc1..604ab597 100644 --- a/examples/example.rb +++ b/examples/example.rb @@ -210,6 +210,21 @@ wb.add_worksheet(:name => "Line Chart") do |sheet| end end +##Generating A Scatter Chart + +wb.add_worksheet(:name => "Scatter Chart") do |sheet| + sheet.add_row ["First", 1, 5, 7, 9] + sheet.add_row ["", 1, 25, 49, 81] + sheet.add_row ["Second", 5, 2, 14, 9] + sheet.add_row ["", 5, 10, 15, 20] + sheet.add_chart(Axlsx::ScatterChart, :title => "example 7: Scatter Chart") do |chart| + chart.start_at 0, 4 + chart.end_at 10, 19 + chart.add_series :xData => sheet["B1:E1"], :yData => sheet["B2:E2"], :title => sheet["A1"] + chart.add_series :xData => sheet["B3:E3"], :yData => sheet["B4:E4"], :title => sheet["A3"] + end +end + ##Auto Filter wb.add_worksheet(:name => "Auto Filter") do |sheet| |