How can I set chart layouts?

Aspose.Cells Product Family
1

I try to set chart layouts from java, but I have not found a class method to do this.

I can change style, type with Chart.setType and Chart.setStyle method.

It chart layout changeble?How?

Thanks.

P.S. I'm speaking about excel feature "chart layouts" visible on Project menù.

2

Hi,

There is no direct way as Ms-Excel provides you with a single click, but there are different properties which you need to set.

Please refer to this article for more help.
Setting Charts Appearance

3

Hi,

in some graph layout excel setting there are some ptoperties that I can't set anyway.

For example: distance from one cylinder to another from 2 different series.

This is possible if you chose 2th or 3th graph layout from excel for cylinder groups histogram chart type, but there aren't any propeties to change it.

4

Hi,

Please create the xlsx files with your desired layout charts, then load it using Aspose.Cells and analyze, which of the properties have been changed, then you will be able to create a chart with the same layout from scratch.