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

Free Support Forum - aspose.com

Remove gray gradient color in 3d Charts

Hi,


How I can remove it in Aspose?
See attachments for more information, screenshots.

I can remove in Excel, but I have not found such property in Aspose.

I have looked at,
//FillFormat fillFormat = aChart.getPlotArea().getArea().getFillFormat();
// fillFormat.setTwoColorGradient(…)
but seems no luck, not changed, even I have commented these lines.

See gradient_.xlsx file for test.

Seems like issue belong only to 3d charts.

Thank you for help.

Hi,


Please use Area.setFormatting() to set it to NONE.

Sample code:

Workbook workbook = new Workbook(path);
Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);
chart.getPlotArea().getArea().setFormatting(FormattingType.NONE);
workbook.save(path + “.out.xlsx”);

Hi, Amjad


Working fine for me.
Thank you.

Hi, Amjad


Sorry, how I can remove now gray color at all?
Also how to remove gray color on ‘Back wall’ ?

Hi,


Please add a line for your requirement:
chart.getWalls().setFormatting(FormattingType.NONE);


Thank you.