From 282eec44ef01746ee25931fa6cd287ad083fd40b Mon Sep 17 00:00:00 2001 From: Zsolt Kozaroczy Date: Fri, 11 Sep 2020 00:36:29 +0200 Subject: Restructure examples folder (#47) Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files. --- examples/hide_gridlines_in_chart_example.md | 33 +++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 examples/hide_gridlines_in_chart_example.md (limited to 'examples/hide_gridlines_in_chart_example.md') diff --git a/examples/hide_gridlines_in_chart_example.md b/examples/hide_gridlines_in_chart_example.md new file mode 100644 index 00000000..e1365bcf --- /dev/null +++ b/examples/hide_gridlines_in_chart_example.md @@ -0,0 +1,33 @@ +## Description + +Bar chart example + +## Code + +```ruby +require 'axlsx' + +p = Axlsx::Package.new +wb = p.workbook + +wb.add_worksheet(name: 'Bar Chart') do |sheet| + sheet.add_row ['A Simple Bar Chart'] + + sheet.add_row ['A', 3] + sheet.add_row ['B', 10] + sheet.add_row ['C', 7] + + sheet.add_chart(Axlsx::Bar3DChart, start_at: 'A6', end_at: 'F20') do |chart| + chart.add_series data: sheet['B2:B4'], labels: sheet['A2:A4'], title: sheet['A1'] + + chart.valAxis.gridlines = false + chart.catAxis.gridlines = false + end +end + +p.serialize 'hide_gridlines_in_chart_example.xlsx' +``` + +## Output + +![Output](images/hide_gridlines_in_chart_example.png "Output") -- cgit v1.2.3