summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorRandy Morgan <[email protected]>2012-03-25 17:44:18 +0900
committerRandy Morgan <[email protected]>2012-03-25 17:44:18 +0900
commitd7ccb09a0aaac4564fe01a56305e68d41ee37f57 (patch)
treee9bb7c031f5f61f6350e4e39004c6a62ed3d723a
parentde8dd68100d228c45aad0e19fa1de204e9265196 (diff)
downloadcaxlsx-d7ccb09a0aaac4564fe01a56305e68d41ee37f57.tar.gz
caxlsx-d7ccb09a0aaac4564fe01a56305e68d41ee37f57.zip
include scatter plot example
-rw-r--r--README.md15
1 files changed, 15 insertions, 0 deletions
diff --git a/README.md b/README.md
index 6a466d34..a0ab2173 100644
--- a/README.md
+++ b/README.md
@@ -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|