Free Support Forum - aspose.com

How Axis line can be made invisible in chart and at the same time scale visible

Hi,

How Axis line can be made invisible in chart and at the same time axis scale be visible.

Please find the attachment. Please provide us the java code.

Hi,



Please use the following code to hide the line of value axis.



Java

chart.getValueAxis().getAxisLine().setVisible(false);

Thanks for the reply.

Hi tired your code. The scale values are appearing, but the axis line is visible. Please provide code which will make the axis line invisible while the scale value should appear.

Please find the excel generated after applying the code you provided.

I am using aspose-cells-2.5.1.jar

Thanks & Regards

Hi,

Please download the latest version:
Aspose.Cells
for Java v2.5.4.20


It is working fine. Please see the output xlsx file attached by me and the code below.

Java


String path = “F:\Shak-Data-RW\Downloads\book1.xlsx”;


Workbook workbook = new Workbook();

workbook.open(path);

Worksheet ws = workbook.getWorksheets().getSheet(0);


Chart ch = ws.getCharts().getChart(0);


ch.getValueAxis().getAxisLine().setVisible(false);


workbook.save(path + “.out.xlsx”);