summaryrefslogtreecommitdiffhomepage
path: root/examples
diff options
context:
space:
mode:
authorRandy Morgan <[email protected]>2012-07-08 12:35:44 +0900
committerRandy Morgan <[email protected]>2012-07-08 12:35:44 +0900
commit7af812c429ffd2374f164fe2f1f4f19ba6cb5f64 (patch)
tree271ae6dfd673b24d900fbf9df9ecb731cce002f0 /examples
parente121fe875ac8492dcd36ba71993e00b2eb4a9ed0 (diff)
downloadcaxlsx-7af812c429ffd2374f164fe2f1f4f19ba6cb5f64.tar.gz
caxlsx-7af812c429ffd2374f164fe2f1f4f19ba6cb5f64.zip
adding in axis line fill and patching view3d misname for line3DChart
Diffstat (limited to 'examples')
-rw-r--r--examples/chart_colors.rb21
1 files changed, 18 insertions, 3 deletions
diff --git a/examples/chart_colors.rb b/examples/chart_colors.rb
index fac3b58e..8349076a 100644
--- a/examples/chart_colors.rb
+++ b/examples/chart_colors.rb
@@ -1,6 +1,6 @@
#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-
-# $LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
+$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
require 'axlsx'
p = Axlsx::Package.new
@@ -36,7 +36,7 @@ end
sheet.add_row ["First", "Second", "Third", "Fourth"]
sheet.add_row [1, 2, 3, "=PRODUCT(A2:C2)"]
sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title => "example 3: Pie Chart") do |chart|
- chart.add_series :data => sheet["A2:D2"], :labels => sheet["A1:D1"], :colors => ['FF0000', '00FF00', '0000FF']
+ chart.add_series :data => sheet["A2:D2"], :labels => sheet["A1:D1"], :colors => ['FF0000', '00FF00', '0000FF', '000000']
end
end
@@ -45,7 +45,7 @@ end
wb.add_worksheet(:name => "Line Chart") do |sheet|
sheet.add_row ["First", 1, 5, 7, 9]
sheet.add_row ["Second", 5, 2, 14, 9]
- sheet.add_chart(Axlsx::Line3DChart, :title => "example 6: Line Chart", :rotX => 30, :rotY => 20) do |chart|
+ sheet.add_chart(Axlsx::Line3DChart, :title => "example 6: Line Chart", :rotX => 30, :rotY => 30) do |chart|
chart.start_at 0, 2
chart.end_at 10, 15
chart.add_series :data => sheet["B1:E1"], :title => sheet["A1"], :color => "FF0000"
@@ -53,6 +53,21 @@ wb.add_worksheet(:name => "Line Chart") do |sheet|
end
end
+wb.add_worksheet(:name => 'Line Chart with Axis colors') do |sheet|
+ sheet.add_row ["First", 1, 5, 7, 9]
+ sheet.add_row ["Second", 5, 2, 14, 9]
+ sheet.add_chart(Axlsx::Line3DChart, :title => "example 7: Flat Line Chart", :rot_x => 0, :perspective => 0) do |chart|
+ chart.valAxis.color = "FFFF00"
+ chart.catAxis.color = "00FFFF"
+ chart.serAxis.delete = true
+ chart.start_at 0, 2
+ chart.end_at 10, 15
+ chart.add_series :data => sheet["B1:E1"], :title => sheet["A1"], :color => "FF0000"
+ chart.add_series :data => sheet["B2:E2"], :title => sheet["A2"], :color => "00FF00"
+ end
+
+end
+
##Generating A Scatter Chart
wb.add_worksheet(:name => "Scatter Chart") do |sheet|