I am evaluating the latest ASPOSE Cell (downloaded 2014-10-01). I generated a line chart with 2 Nseries
let ws = wb.Worksheets.
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.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#
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.
string filePath = @“F:\Shak-Data-RW\Downloads\sample.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets;
int idx = worksheet.Charts.Add(ChartType.Line, 3, 3, 17, 11);
Chart chartRef = worksheet.Charts[idx];
chartRef.NSeries.Name = “=A1”;
chartRef.NSeries.Name = “=B1”;
chartRef.Legend.Position = LegendPositionType.Bottom;
chartRef.PlotArea.Area.FillFormat.Type = Aspose.Cells.Drawing.FillType.None;