Change the position of axis when enable ShowDataTable

Aspose.Cells Product Family
1

Hi Team,

We are using aspose cell 8.3.2.1 for extracting chart as image from input excel document. here we have enable the ShowDataTable option of chart so that chart image have data table.

But after enable the ShowDataTable option, aspose change the position of line axis. please find the attached before images and after images and see the difference.

myChart.ShowDataTable = true;
myChart.ChartArea.Area.BackgroundColor = Color.Brown;
myChart.AutoScaling = true;
myChart.ShowLegend = true;
myChart.Title.Text = string.Empty;
myChart.ChartArea.Border.IsVisible = true;
myChart.ValueAxis.MajorGridLines.IsVisible = true;

//Convert the chart to an image file.
myChart.ToImage(ImgPath+"\"+i+".png", System.Drawing.Imaging.ImageFormat.Png);

Could you please let us know how we can fix this issue by aspose cell and what is the alternative way to enable data table with chart. its very high priority issue



Thanks,
Monika

2

Hi Monika,


Thank you for contacting Aspose support. Please share the input spreadsheet so we could thoroughly investigate the presented scenario on our side.