Chart setup

Aspose.Cells Product Family
1

Hi.

I unable to find out a way for easy setup chart on data table.

For example:

  • i have a table of data, when first column is a category and others are series data columns
  • first row is a names of series

Is there a way for easy setup chart (like i do it via Excel) something like following:

@Test
public void createTest() throws Exception {
    Workbook wb = new Workbook(“D://chart.xlsx”);

    ChartCollection charts = wb.getWorksheets().get(1).getCharts();

    int i = charts.add(ChartType.LINE, 0, 0, 25, 10);
    Chart chart = charts.get(i);

    chart.setDataSource(“Data!A1:B6”);
    //chart.getNSeries().add(“Data!A1:B6”, true);

    wb.save(“D://out.xlsx”);
}

And i expect, that chart will setup, like in Excel. But there is no same method. I have founded only “chart.getNSeries().add”, but it works by another way.

Best regards. Alexey

2

And also will very usefull to create Range by String. For example:


Range range = workbook.getRange(“Data!A1:B6”);

It could helps for many points
3

Hi Alexeu,

Thanks for your posting and considering Aspose.Cells.

We have logged a New Feature request in our database to support this feature of easy way to setup chart.

We will look into it and see if we could implement it. Once, there is some news for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41289 - Easy way for Chart setup

4

The issues you have found earlier (filed as CELLSJAVA-41289) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
5

Hi,

Thanks for using Aspose.Cells.

We have supported this feature. Please use the latest version: Aspose.Cells for Java 8.4.2.

Please call setChartDataRange(String area, boolean isVertical) with new version 8.4.2.