Free Support Forum - aspose.com

Problem size grid chart

I was using aspose cells to extract a image with a grid in a lineachart.

The problem is that is imposible for me define the size of the table with the results. One time apeear wither than others…
I tried putting:
chart.ChartArea.Width = 300;
but not define the table , only defines the total image.

Hi Alfonso.

Thank you for contacting Aspose support.

I am afraid, your requirement is not clear to me. It would be appropriate if you can share a sample spreadsheet along with more details of your scenario. You can also use snapshots of the area that you wish to resize.

i have with different parameters of entry but the same with in chart different sizes in table. How is possible define the size of area data

Hi Alfonso.

Please try the following piece of code with your desired chart and see if it fulfills your requirement. Please note, the code increases the width of the ChartShape. Attached are the input & output spreadsheets for your reference.

C#


Workbook book = new Workbook(SourceFileName);
Worksheet sheet = book.Worksheets[0];
Chart chart = sheet.Charts[0];
chart.ChartObject.Width = chart.ChartObject.Width + 100;
book.Save(“D:/output.xlsx”, SaveFormat.Xlsx);

thanks for all!!!

You give us a great proffesional service.
Seguros Rga.

Hi Seguros,


It is good to know that the provided solution helped in your scenario. Please feel free to contact us back in case you need our further assistance with Aspose APIs.