Hello, thanks for implementing FirstSliceAngel property of chart.
I’ve got another troubles. I need the charts of types (Aspose.Excel.ChartType.Pie, Aspose.Excel.ChartType.Column, Aspose.Excel.ChartType.LineWithDataMarkers)
to have the same look as in my application. To achieve this goal i need to set the color and pattern for the items of each type of chart.
Everithing is fine for Aspose.Excel.ChartType.LineWithDataMarkers type.
For Aspose.Excel.ChartType.Column type i want to set pattern: aSeries.Area.FillFormat.Pattern = BackgroundType.ReverseDiagonalStripe; but when i open the file in excel the pattern is not set. Am i doing smth wrong or this feature is not implemented yet?
For Aspose.Excel.ChartType.Pie type Aspose create only one NSeries item. So i can’t even set a color and pattern for each slice of pie.
Can you explain me if it possible to do it using Aspose?
@DIX,
Aspose.Excel is discontinued and no more under active development now. It is replaced with an advanced product Aspose.Cells that contains support for all the features in Aspose.Excel as well as supports the latest features in different versions of MS Excel. You can set chart appearance using Aspose.Cells as demonstrated in the following sample code:
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
System.IO.Directory.CreateDirectory(dataDir);
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Adding a new worksheet to the Workbook object
int sheetIndex = workbook.Worksheets.Add();
// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];
// Adding sample values to cells
worksheet.Cells["A1"].PutValue(50);
worksheet.Cells["A2"].PutValue(100);
worksheet.Cells["A3"].PutValue(150);
worksheet.Cells["B1"].PutValue(60);
worksheet.Cells["B2"].PutValue(32);
worksheet.Cells["B3"].PutValue(50);
// Adding a chart to the worksheet
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5);
// Accessing the instance of the newly added chart
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];
// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.NSeries.Add("A1:B3", true);
// Setting the foreground color of the plot area
chart.PlotArea.Area.ForegroundColor = Color.Blue;
// Setting the foreground color of the chart area
chart.ChartArea.Area.ForegroundColor = Color.Yellow;
// Setting the foreground color of the 1st SeriesCollection area
chart.NSeries[0].Area.ForegroundColor = Color.Red;
// Setting the foreground color of the area of the 1st SeriesCollection point
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan;
// Filling the area of the 2nd SeriesCollection with a gradient
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1);
// Saving the Excel file
workbook.Save(dataDir + "book1.out.xls");
The following document contains a detailed description of this feature: Setting Chart Appearance