diff options
| author | Jurriaan Pruis <[email protected]> | 2012-03-27 13:55:42 +0200 |
|---|---|---|
| committer | Jurriaan Pruis <[email protected]> | 2012-03-27 13:55:42 +0200 |
| commit | 3867eb132f20c3258f007ca61a738e90a09087dc (patch) | |
| tree | e8d0b196badf01ceefe56aa02ac40ad82371afce /README.md | |
| parent | 5afd30be1774fb5255dad2eb18c700d0d8f4a628 (diff) | |
| parent | be2d7bee9b9236fff4a378db8770c3ae793e8422 (diff) | |
| download | caxlsx-3867eb132f20c3258f007ca61a738e90a09087dc.tar.gz caxlsx-3867eb132f20c3258f007ca61a738e90a09087dc.zip | |
Merge github.com:randym/axlsx
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 15 |
1 files changed, 15 insertions, 0 deletions
@@ -264,6 +264,21 @@ To install Axlsx, use the following command: 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| |
