chart_radar.rb in write_xlsx-1.09.5

- old
+ new

@@ -14,36 +14,36 @@
 workbook  = WriteXLSX.new('chart_radar.xlsx')
 worksheet = workbook.add_worksheet
 bold      = workbook.add_format(:bold => 1)
 
 # Add the worksheet data that the charts will refer to.
-headings = [ 'Number', 'Batch 1', 'Batch 2' ]
+headings = ['Number', 'Batch 1', 'Batch 2']
 data = [
-    [ 2, 3, 4, 5, 6, 7 ],
-    [ 30, 60, 70, 50, 40, 30 ],
-    [ 25, 40, 50, 30, 50, 40 ]
+  [2, 3, 4, 5, 6, 7],
+  [30, 60, 70, 50, 40, 30],
+  [25, 40, 50, 30, 50, 40]
 ]
 
 worksheet.write('A1', headings, bold)
 worksheet.write('A2', data)
 
 # Create a new chart object. In this case an embedded chart.
 chart1 = workbook.add_chart(:type => 'radar', :embedded => 1)
 
 # Configure the first series.
 chart1.add_series(
-    :name       => '=Sheet1!$B$1',
-    :categories => '=Sheet1!$A$2:$A$7',
-    :values     => '=Sheet1!$B$2:$B$7'
+  :name       => '=Sheet1!$B$1',
+  :categories => '=Sheet1!$A$2:$A$7',
+  :values     => '=Sheet1!$B$2:$B$7'
 )
 
 # Configure second series. Note alternative use of array ref to define
 # ranges: [ sheetname, row_start, row_end, col_start, col_end ].
 chart1.add_series(
-    :name       => '=Sheet1!$C$1',
-    :categories => [ 'Sheet1', 1, 6, 0, 0 ],
-    :values     => [ 'Sheet1', 1, 6, 2, 2 ]
+  :name       => '=Sheet1!$C$1',
+  :categories => ['Sheet1', 1, 6, 0, 0],
+  :values     => ['Sheet1', 1, 6, 2, 2]
 )
 
 # Add a chart title and some axis labels.
 chart1.set_title(:name => 'Results of sample analysis')
 chart1.set_x_axis(:name => 'Test number')
@@ -60,27 +60,27 @@
 
 #
 # Create a with_markers chart sub-type
 #
 chart2 = workbook.add_chart(
-                            :type     => 'radar',
-                            :embedded => 1,
-                            :subtype  => 'with_markers'
-                            )
+  :type     => 'radar',
+  :embedded => 1,
+  :subtype  => 'with_markers'
+)
 
 # Configure the first series.
 chart2.add_series(
-    :name       => '=Sheet1!$B$1',
-    :categories => '=Sheet1!$A$2:$A$7',
-    :values     => '=Sheet1!$B$2:$B$7'
+  :name       => '=Sheet1!$B$1',
+  :categories => '=Sheet1!$A$2:$A$7',
+  :values     => '=Sheet1!$B$2:$B$7'
 )
 
 # Configure second series.
 chart2.add_series(
-    :name       => '=Sheet1!$C$1',
-    :categories => [ 'Sheet1', 1, 6, 0, 0 ],
-    :values     => [ 'Sheet1', 1, 6, 2, 2 ]
+  :name       => '=Sheet1!$C$1',
+  :categories => ['Sheet1', 1, 6, 0, 0],
+  :values     => ['Sheet1', 1, 6, 2, 2]
 )
 
 # Add a chart title and some axis labels.
 chart2.set_title(:name  => 'Stacked Chart')
 chart2.set_x_axis(:name => 'Test number')
@@ -97,26 +97,26 @@
 
 #
 # Create a filled chart sub-type
 #
 chart3 = workbook.add_chart(
-                            :type     => 'radar',
-                            :embedded => 1,
-                            :subtype  => 'filled'
-                            )
+  :type     => 'radar',
+  :embedded => 1,
+  :subtype  => 'filled'
+)
 
 # Configure the first series.
 chart3.add_series(
-    :name       => '=Sheet1!$B$1',
-    :categories => '=Sheet1!$A$2:$A$7',
-    :values     => '=Sheet1!$B$2:$B$7'
+  :name       => '=Sheet1!$B$1',
+  :categories => '=Sheet1!$A$2:$A$7',
+  :values     => '=Sheet1!$B$2:$B$7'
 )
 
 # Configure second series.
 chart3.add_series(
-    :name       => '=Sheet1!$C$1',
-    :categories => [ 'Sheet1', 1, 6, 0, 0 ],
-    :values     => [ 'Sheet1', 1, 6, 2, 2 ]
+  :name       => '=Sheet1!$C$1',
+  :categories => ['Sheet1', 1, 6, 0, 0],
+  :values     => ['Sheet1', 1, 6, 2, 2]
 )
 
 # Add a chart title and some axis labels.
 chart3.set_title(:name  => 'Percent Stacked Chart')
 chart3.set_x_axis(:name => 'Test number')