Read XSSFPivotTable to chart

[Jonathan Ortiz]

Hi,

I have created a Excel Pivot Table XSSFPivotTable:

                        //Configure the pivot table
                        String area="A1:I"+last_row;
                        AreaReference ar = new AreaReference(area);
                        CellReference cr = new CellReference("A1");
                        XSSFPivotTable pivotTable =
pivot_sheet.createPivotTable(ar,cr,my_sheet);
                        //Use first column as row label
                        pivotTable.addRowLabel(0);
                        addColLabel(pivotTable,8);

pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 7);

And works fine but the next step will be create a Chart from PivotTable but
i don´t find any documentation as i can read cell values from
XSSFPivotTable to create a Chart.

Thanks in advance