Free Support Forum - aspose.com

Issue with Aspose cells java Chart type COLUMN

Aspose.Cells Product Family
#1

Hi, I am not able to generate the COLUMN chart with a given data set. I have attached the xlsx file which shows two charts:
1st chart is the one I generated with the code I wrote with aspose cells java
2nd is the actual output I needed.

Please help me to generate the chart in desired manner.
column chart.zip (13.5 KB)
(13.6 KB)

Thanks,
Balakumar

#2

@BalakumarSeethapathy,

Thanks for the template file.

Please use/add the following lines of code to your code segment for adding data series and category data to mimic your expected chart:
e.g
Sample code:

.........
chart.getNSeries().add("C42:C45", true);
chart.getNSeries().setCategoryData("B42:B45");
..........

Hope, this helps a bit.

Thank you.

#3

Hi,
Is it possible to add data coordinates in R1C1 format for:
chart.getNSeries().add(“C42:C45”, true);
chart.getNSeries().setCategoryData(“B42:B45”);

Thanks,
Balakumar

#4

@BalakumarSeethapathy,

Yes, you may try to use SeriesCollection.addR1C1() method to add data series in R1C1 formula.

Thank you.