summaryrefslogtreecommitdiffhomepage
path: root/examples
diff options
context:
space:
mode:
authorJoe Kain <[email protected]>2012-03-23 22:10:55 -0700
committerJoe Kain <[email protected]>2012-03-23 22:10:55 -0700
commite9bfaf8ddbb1995da906dbca6b650ff06b4afe75 (patch)
tree86d1180c2883792aca926fc8bc1a701c14326941 /examples
parent8a0f840313df5ab5543b491d475650b1b63b558e (diff)
downloadcaxlsx-e9bfaf8ddbb1995da906dbca6b650ff06b4afe75.tar.gz
caxlsx-e9bfaf8ddbb1995da906dbca6b650ff06b4afe75.zip
Add Scatter Chart example.
Diffstat (limited to 'examples')
-rw-r--r--examples/example.rb15
1 files changed, 15 insertions, 0 deletions
diff --git a/examples/example.rb b/examples/example.rb
index 36fe6b37..e85c1fd5 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|