examples/chart_pie.rb in write_xlsx-1.09.4 vs examples/chart_pie.rb in write_xlsx-1.09.5

- old
+ new

@@ -20,14 +20,14 @@ workbook = WriteXLSX.new('chart_pie.xlsx') worksheet = workbook.add_worksheet bold = workbook.add_format(:bold => 1) # Add the worksheet data that the charts will refer to. -headings = [ 'Category', 'Values' ] +headings = %w[Category Values] data = [ - [ 'Apple', 'Cherry', 'Pecan' ], - [ 60, 30, 10 ] + %w[Apple Cherry Pecan], + [60, 30, 10] ] worksheet.write('A1', headings, bold) worksheet.write('A2', data) @@ -36,13 +36,13 @@ # Configure the series. Note the use of the array ref to define ranges: # [ $sheetname, $row_start, $row_end, $col_start, $col_end ]. # See below for an alternative syntax. chart1.add_series( - :name => 'Pie sales data', - :categories => [ 'Sheet1', 1, 3, 0, 0 ], - :values => [ 'Sheet1', 1, 3, 1, 1 ] + :name => 'Pie sales data', + :categories => ['Sheet1', 1, 3, 0, 0], + :values => ['Sheet1', 1, 3, 1, 1] ) # Add a title. chart1.set_title(:name => 'Popular Pie Types') @@ -62,18 +62,18 @@ # Create an example Pie chart like above. chart2 = workbook.add_chart(:type => 'pie', :embedded => 1) # Configure the series. chart2.add_series( - :name => 'Pie sales data', - :categories => '=Sheet1!$A$2:$A$4', - :values => '=Sheet1!$B$2:$B$4', - :points => [ - { :fill => { :color => '#5ABA10' } }, - { :fill => { :color => '#FE110E' } }, - { :fill => { :color => '#CA5C05' } } - ] - ) + :name => 'Pie sales data', + :categories => '=Sheet1!$A$2:$A$4', + :values => '=Sheet1!$B$2:$B$4', + :points => [ + { :fill => { :color => '#5ABA10' } }, + { :fill => { :color => '#FE110E' } }, + { :fill => { :color => '#CA5C05' } } + ] +) # Add a title. chart2.set_title(:name => 'Pie Chart with user defined colors') worksheet.insert_chart(