We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to switch Row/Column for chart in Apose.Cells

How it is possible to switch Row/Column for chart data in Aspose.Cells Java.


(I can make it in excel simply via button when you select data for you chart)

Thank you.

Hi,

Thanks for your posting and using Aspose.Cells for Java.

It seems to me this feature is no available as yet. So I have logged a New Feature request for this issue.

Development team will look into it and provide you this feature or if we have some other update for you, we will let you know asap.

This issue has been logged as a New Feature Request with id: CELLSJAVA-40155

Hi,


Check the method i.e. SeriesCollection.add(), you may specify true or false for “isVertical” parameter to plot the series by row or column, see the method description:

add

public int add(java.lang.String area, boolean isVertical)
Adds the SeriesCollection collection to a chart.
If set data on contiguous cells, use colon to seperate them.For example, C2:C5.

If set data on non contiguous cells, use comma to seperate them.For example, C2,D5.
Parameters:
area - Specifies values from which to plot the data series
isVertical - Specifies whether to plot the series from a range of cell values by row or by column.
Returns:
Return the first index of the added ASeries in the NSeries.




Check the document for reference:
http://docs.aspose.com/display/cellsjava/Setting+Charts+Data


Thank you.