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,