How to make graph on pivot table with axlsx

[drgcms]

If I try to make a graph on a result of a pivot table, the program ends in error.

ArgumentError (Missing cell B228 for the specified range B228:B233)

This makes me think that pivot table data is not really created until it is opened in LO or Excel. Is it possible to mitigate the error and put graph data on the sheet anyway?

    n_row = 223  # row number that program ended preparing data
    sheet.add_pivot_table "A#{n_row + 2}:C#{n_row + 10}", "L1:L#{n_row}" do |pivot_table|
      pivot_table.rows    = ['Group']
      pivot_table.data = [ref: 'Group', :subtotal => 'count', num_fmt: 4]
    end

   sheet.add_chart(Axlsx::Bar3DChart, start_at: "D#{n_row + 2}", end_at: "E#{n_row + 20}") do |chart|
      chart.add_series data: sheet["B#{n_row + 5}:B#{n_row + 10}"],
                       labels: sheet["A#{n_row + 5}:A#{n_row + 10}"],
                       title: "Graph by groups",
                       colors: @products.map { "00FF00" }
   end

by
TheR

[github-actions]

This issue has been automatically marked as stale because it has not been commented on for at least three months.
If you have any new information or updates please reply in order to keep the issue open.