Horizontal Axis of Line thickness

Aspose.Cells Product Family
1

Hi



I am evaluating the latest ASPOSE Cell (downloaded 2014-10-01). I generated a line chart with 2 Nseries



let ws = wb.Worksheets.[1]



let chartindex = ws.Charts.Add(Charts.ChartType.Line,5,0,15,15)



let chartRef = ws.Charts.[chartindex]



let cs1 = chartRef.NSeries.Add(“Sheet1!$F$2:$F$5000”,true)



let cs2 = chartRef.NSeries.Add(“Sheet1!$AC$2:$AC$5000”,true)



chartRef.NSeries.[cs1].Name


chartRef.Legend.Position <- Charts.LegendPositionType.Bottom



chartRef.PlotArea.Area.FillFormat.Type <- Drawing.FillType.None





however the horizon Axis thickness is way off. it is very thick. however the format window saying the thickness is only 0.75 pt.



Can you please advise?



.net version 4.5

language F# and C#

windows 8

Excel 2010



Thanks

casbbyli

2

Hi Casbbyli,

Thanks for your posting and using Aspose.Cells.

We generated the line chart with the following sample code using the version: Aspose.Cells for .NET (Latest Version) and did not find any issue.

I have attached the sample xlsx file used in this code and the output xlsx file generated by the code and screenshot showing the output chart for your reference.

If you still find any issue, please provide us your runnable sample project and your actual and expected output Excel files. You can give us your expected output file by manually editing it using Microsoft Excel.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\sample.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


int idx = worksheet.Charts.Add(ChartType.Line, 3, 3, 17, 11);


Chart chartRef = worksheet.Charts[idx];


chartRef.NSeries.Add(“A2:B10”, true);

chartRef.NSeries[0].Name = “=A1”;

chartRef.NSeries[1].Name = “=B1”;


chartRef.Legend.Position = LegendPositionType.Bottom;

chartRef.PlotArea.Area.FillFormat.Type = Aspose.Cells.Drawing.FillType.None;


workbook.Save(“output.xlsx”);