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
@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.
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
@BalakumarSeethapathy,
Yes, you may try to use SeriesCollection.addR1C1() method to add data series in R1C1 formula.
Thank you.