Patterns and Colors for Charts

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.

Aspose.Excel.ASeries aSeries = chart.NSeries[iSeries];
aSeries.Line.Color = cell.Style.ForegroundColor;
aSeries.Line.Style = LineType.Dot;

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?





The above features are not implemented yet. I will work on it right now. It will be available in about one week.

Please download v2.7.5

These features are available now.

To set color for each slice of pie, please try this:

ASeries aseries = chart.NSeries[0];
aseries.Points[0].Area.ForegroundColor = Color.Yellow;
aseries.Points[1].Area.ForegroundColor = Color.Red;

@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

A free latest trial version of this product is available here:
Aspose.Cells for .NET (Latest Version)

You can test all the features of this product by downloading a runnable solution here.