Pie chart format issue

Aspose.Cells Product Family
1

Hi Team,

Could you please share my query to support team because I am not able to find out the support email.

And please add me as well in forwarded email to support team.

Regards,

Uttam Mishra

From: Sales [mailto:sales@aspose.com]
Sent: Tuesday, June 28, 2016 12:59 PM
To: Uttam Kumar Mishra
Subject: RE: Issue with Aspose pdf pie chart

Hi Uttam,

Thank you for your enquiry.

All technical matters are addressed by our Support Team in the forums so please post on the appropriate Product Family forum at https://forum.aspose.com and our Support Team there will be glad to help.

Kind regards,

George.

George Clark
Aspose Sales

Your File Format Experts
Tel +44 141 416 1112
Skype AsposeScotland

Keep in touch! We’re on Twitter and Facebook

From: Uttam Kumar Mishra [mailto:uttam.kumar.mishra@Aonhewitt.com]
Sent: 28 June 2016 08:26
To: Sales sales@aspose.com
Subject: Issue with Aspose pdf pie chart

Hi Team,

I am working with Aspose pdf pie chart and I am facing some issue with pie chart leader line alignment.

Below is my requirement with my pie chart:

But currently I am getting below output with my below c# code:

Issues are with my current output :

  1. The height and width not able to perform like above pie chart.

  2. The leaderlines are not working properly like above pie chart.

  3. The legends are not displaying like above.

And my pie chart code is:


Chart chart = sheet.Charts[chartIndex];

for (int i = 0; i <= chart.NSeries.Count - 1; i++)

{

chart.NSeries[i].IsColorVaried = true;

chart.ShowLegend = false;

DataLabels dataLabels = chart.NSeries[i].DataLabels;

chart.ShowLegend = true;

chart.ChartObject.Height = 300;

chart.ChartObject.Width = 1100;

dataLabels.Height = 3;

dataLabels.ShowCategoryName = false;

dataLabels.ShowPercentage = true;

dataLabels.Position = LabelPositionType.Below;

dataLabels.ShowLegendKey = true;

dataLabels.Separator = DataLablesSeparatorType.Space;

dataLabels.ShowValue = false;

dataLabels.Number = 10;

chart.NSeries[i].HasLeaderLines = false;

chart.NSeries[i].LeaderLines.IsAuto = false;

chart.Calculate();

for (int j = 0; j < chart.NSeries[i].Points.Count; j++)

{

chart.NSeries[i].Points[j].Area.ForegroundColor = columnColors[colorNum];

chart.NSeries[i].Points[j].Border.Color = System.Drawing.Color.FromArgb(255, 255, 255);

if (colorNum == 47)

colorNum = 55;

else

colorNum--;

}

}

Please suggest.

Regards,

Uttam Mishra

This message was posted using Support2Forum.

2

Hi,


Thanks for sharing the details.

Please do the needful (as requested in your other thread). If you are using Aspose.Cells APIs, kindly provide us a simple console application (you may zip it prior attaching here), template input and output Excel file (by Aspose.Cells APIs), we will check it soon. Also provide an Excel file (containing your desired chart), you may create your desired output Excel file with chart in MS Excel manually. This will help us really to evaluate your issue precisely to figure it out soon.

Thank you.

3

HI,


I am not able to attach due to access in office premises.
I can email you if any email id is available directly.

Regards,
Uttam
4

Hi,


Please upload the archive(s) on dropbox or google drive and provide us download link here in this thread. If you want, we can also make your thread Private so that only you and Aspose Staff members could access it, no other users could open your thread or read contents/attachments.

Thank you.