Hi,
Thank you for considering Aspose.
Please call Chart.Calculate(); before saving the file. Please see following code:
Workbook wb = new Workbook();
wb.Open(@"F:\FileTemp\files\ColumnChartDemo.xls");
Worksheet wsChart = wb.Worksheets[0];
//Erzeugen des Diagramms und setzen der wesentlichen Eigenschaften
int chartIndex = wsChart.Charts.Add(ChartType.Column, 1, 1, 25, 10);
Chart chart = wsChart.Charts[chartIndex];
//Hauptgridzeielen einblenden
chart.MajorGridLines.IsVisible = true;
//Grundfarbe weiß
chart.PlotArea.Area.ForegroundColor = System.Drawing.Color.White;
//Kein umschließender Rahmen
chart.ChartArea.Border.IsVisible = false;
//Festlegung der Datenquelle
chart.NSeries.Add("'Data'!B2:B11", true);
chart.NSeries.Add("'Data'!B2:B11", true);
chart.NSeries.Add("'Data'!C2:C11", true);
chart.NSeries.Add("'Data'!C2:C11", true);
chart.NSeries.CategoryData = "'Data'!A2:A11";
chart.NSeries.SecondCatergoryData = "'Data'!A2:A11";
chart.NSeries[0].Name = "Master1";
chart.NSeries[1].Name = "Master2";
chart.NSeries[1].Line.IsVisible = false;
chart.NSeries[1].Area.Formatting = FormattingType.None;
chart.NSeries[2].Name = "Detail1";
chart.NSeries[2].PlotOnSecondAxis = true;
chart.NSeries[2].Line.IsVisible = false;
chart.NSeries[2].Area.Formatting = FormattingType.None;
chart.NSeries[3].Name = "Detail2";
chart.NSeries[3].PlotOnSecondAxis = true;
chart.SecondValueAxis.IsVisible = true;
chart.SecondValueAxis.Crosses = CrossType.Automatic;
//Legende Ausblenden
chart.IsLegendShown = false;
//Platzierung auf der Folie vornehmen
chart.ChartObject.HeightCM = 14;
chart.ChartObject.WidthCM = 25;
chart.ChartObject.UpperLeftColumn = 2;
chart.ChartObject.UpperLeftRow = 7;
chart.Placement = PlacementType.FreeFloating;
FileStream stream = new FileStream(@"F:\FileTemp\files\logochart.bmp", FileMode.Open, FileAccess.Read);
Picture pic0 = chart.Shapes.AddPictureInChart(375, 250, stream, 90, 90);
chart.Calculate();
wb.Save(@"F:\FileTemp\files\reportColumnAspose.pdf", FileFormatType.Pdf);
wb.Save(@"F:\FileTemp\files\reportColumnAspose.xls");
Thank You & Best Regards,