Set margin in area chart in Excel spreadsheet via Aspose.Cells in .NET

Aspose.Cells Product Family
1
Good afternoon,

I hope you can help me.
I am creating a graphic chart and have the problem that I can not set the margins on the left and right of the first and last data, I would not have margin.


Thanks for everything.
2

Hi Juan,

Thanks for your posting and using Aspose.Cells.

Please manually create your desired Chart in Microsoft Excel and attach your Excel file here for our reference. We will look into it and let you know the sample code to achieve your desired output Chart using Aspose.Cells APIs.

It will also be helpful if you let us know the steps you took in Microsoft Excel to create such margins. Thanks for your cooperation.

3
Good Morning,

The sample excel attachment

Thanks
4

Hi Juan,

Thanks for your posting and using Aspose.Cells.

You need to set Chart.CategoryAxis.AxisBetweenCategories property to false. Please see the following sample code. I have attached the output Excel file generated by it for your reference.

C#


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


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


int idx = worksheet.Charts.Add(ChartType.Area, 18, 3, 32, 9);


Chart ch = worksheet.Charts[idx];

ch.NSeries.Add(“A1:A12”, true);

ch.ShowLegend = false;


//You need to set this property false

ch.CategoryAxis.AxisBetweenCategories = false;


workbook.Save(“output.xlsx”);