chart_combined.rb in write_xlsx-1.10.1

- old
+ new

@@ -11,11 +11,11 @@
 
 require 'write_xlsx'
 
 workbook  = WriteXLSX.new('chart_combined.xlsx')
 worksheet = workbook.add_worksheet
-bold      = workbook.add_format(:bold => 1)
+bold      = workbook.add_format(bold: 1)
 
 # Add the worksheet data that the charts will refer to.
 headings = ['Number', 'Batch 1', 'Batch 2']
 data = [
   [2,  3,  4,  5,  6,  7],
@@ -30,78 +30,78 @@
 # In the first example we will create a combined column and line chart.
 # They will share the same X and Y axes.
 #
 
 # Create a new column chart. This will use this as the primary chart.
-column_chart1 = workbook.add_chart(:type => 'column', :embedded => 1)
+column_chart1 = workbook.add_chart(type: 'column', embedded: 1)
 
 # Configure the data series for the primary chart.
 column_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'
 )
 
 # Create a new column chart. This will use this as the secondary chart.
-line_chart1 = workbook.add_chart(:type => 'line', :embedded => 1)
+line_chart1 = workbook.add_chart(type: 'line', embedded: 1)
 
 # Configure the data series for the secondary chart.
 line_chart1.add_series(
-  :name       => '=Sheet1!$C$1',
-  :categories => '=Sheet1!$A$2:$A$7',
-  :values     => '=Sheet1!$C$2:$C$7'
+  name:       '=Sheet1!$C$1',
+  categories: '=Sheet1!$A$2:$A$7',
+  values:     '=Sheet1!$C$2:$C$7'
 )
 
 # Combine the charts.
 column_chart1.combine(line_chart1)
 
 # Add a chart title and some axis labels. Note, this is done via the
 # primary chart.
-column_chart1.set_title(:name => 'Combined chart - same Y axis')
-column_chart1.set_x_axis(:name => 'Test number')
-column_chart1.set_y_axis(:name => 'Sample length (mm)')
+column_chart1.set_title(name: 'Combined chart - same Y axis')
+column_chart1.set_x_axis(name: 'Test number')
+column_chart1.set_y_axis(name: 'Sample length (mm)')
 
 # Insert the chart into the worksheet
 worksheet.insert_chart('E2', column_chart1)
 
 #
 # In the second example we will create a similar combined column and line
 # chart except that the secondary chart will have a secondary Y axis.
 #
 
 # Create a new column chart. This will use this as the primary chart.
-column_chart2 = workbook.add_chart(:type => 'column', :embedded => 1)
+column_chart2 = workbook.add_chart(type: 'column', embedded: 1)
 
 # Configure the data series for the primary chart.
 column_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'
 )
 
 # Create a new column chart. This will use this as the secondary chart.
-line_chart2 = workbook.add_chart(:type => 'line', :embedded => 1)
+line_chart2 = workbook.add_chart(type: 'line', embedded: 1)
 
 # Configure the data series for the secondary chart. We also set a
 # secondary Y axis via (y2_axis). This is the only difference between
 # this and the first example, apart from the axis label below.
 line_chart2.add_series(
-  :name       => '=Sheet1!$C$1',
-  :categories => '=Sheet1!$A$2:$A$7',
-  :values     => '=Sheet1!$C$2:$C$7',
-  :y2_axis    => 1
+  name:       '=Sheet1!$C$1',
+  categories: '=Sheet1!$A$2:$A$7',
+  values:     '=Sheet1!$C$2:$C$7',
+  y2_axis:    1
 )
 
 # Combine the charts.
 column_chart2.combine(line_chart2)
 
 # Add a chart title and some axis labels.
-column_chart2.set_title(:name => 'Combine chart - secondary Y axis')
-column_chart2.set_x_axis(:name => 'Test number')
-column_chart2.set_y_axis(:name => 'Sample length (mm)')
+column_chart2.set_title(name: 'Combine chart - secondary Y axis')
+column_chart2.set_x_axis(name: 'Test number')
+column_chart2.set_y_axis(name: 'Sample length (mm)')
 
 # NOTE: the y2 properties are on the secondary chart.
-line_chart2.set_y_axis(:name => 'Target length (mm)')
+line_chart2.set_y_axis(name: 'Target length (mm)')
 
 # Insert the chart into the worksheet
 worksheet.insert_chart('E18', column_chart2)
 
 workbook.close