Hi,
I am near to the solution but stopped by an issue with applying "Transparency" property. I am setting the transperency value between 0 to 1 but it was not applying.
Please see the blow code and attached generated excel workbook. Could you please send me the solution ASAP because i needs to deliver this report to high level management.
CODE :
//
//Voluntary Turnover Count
//
Series seriesVoluntaryTurnoverCount = chart.NSeries[1];
seriesVoluntaryTurnoverCount.Name = "Voluntary Turnover Count";
seriesVoluntaryTurnoverCount.Area.FillFormat.Pattern = FillPattern.Solid;
seriesVoluntaryTurnoverCount.Area.ForegroundColor = Color.FromArgb(23, 55, 94);
seriesVoluntaryTurnoverCount.Area.BackgroundColor = Color.FromArgb(23, 55, 94);
seriesVoluntaryTurnoverCount.Area.Transparency = 0.37;
seriesVoluntaryTurnoverCount.DataLabels.ShowValue = true;
seriesVoluntaryTurnoverCount.DataLabels.Position = LabelPositionType.InsideBase;
seriesVoluntaryTurnoverCount.DataLabels.Font.IsBold = true;
seriesVoluntaryTurnoverCount.GapWidth = 25;
//
//
//Involuntary Count
//
Series seriesInvoluntaryTurnoverCount = chart.NSeries[2];
seriesInvoluntaryTurnoverCount.Name = "Involuntary Turnover Count";
seriesInvoluntaryTurnoverCount.Area.FillFormat.Pattern = FillPattern.Solid;
seriesInvoluntaryTurnoverCount.Area.ForegroundColor = Color.FromArgb(142, 180, 227);
seriesInvoluntaryTurnoverCount.Area.BackgroundColor = Color.FromArgb(142, 180, 227);
seriesInvoluntaryTurnoverCount.Area.Transparency = 0.61;
seriesInvoluntaryTurnoverCount.DataLabels.ShowValue = true;
seriesInvoluntaryTurnoverCount.DataLabels.Position = LabelPositionType.InsideEnd;
seriesInvoluntaryTurnoverCount.DataLabels.Font.IsBold = true;
//
//
//Turnover Rate%
//
Series seriesTurnoverRate = chart.NSeries[3];
seriesTurnoverRate.Name = "Turnover Rate";
seriesTurnoverRate.Type = ChartType.Line;
seriesTurnoverRate.Border.Style = LineType.Solid;
seriesTurnoverRate.Border.WeightPt = 2.25;
seriesTurnoverRate.Border.Color = Color.Red;
seriesTurnoverRate.DataLabels.ShowValue = true;
seriesTurnoverRate.DataLabels.Position = LabelPositionType.Below;
seriesTurnoverRate.DataLabels.Number = 9;
seriesTurnoverRate.PlotOnSecondAxis = true;
//
//
//Format Chart
//
chart.CategoryAxis.TickLabels.NumberFormat = "MMM-yy";
chart.SecondValueAxis.IsVisible = true;
//