Bar Chart and Bubble Chart colors

Aspose.Cells Product Family
1

Laurence,

I am evaluating Aspose.Excel for replacing what we now have in our application. One thing that is an absolutely essential requirement is the ability to specify the colors of the bars or the bubbles in the charts. Is that possible in this product?

Thanks,
Rick

2

Hi Rick,

Yes, Aspose.Excel supports this feature. Please try the following code:

chart.NSeries[0].Area.ForegroundColor = Color.Blue;

3

@rschoenborn,
This is to inform you that we have introduced a new product Aspose.Cells which has replaced Aspose.Excel. No more development is done for Aspose.Excel now. The new product Aspose.Cells has provided many rich features to work with charts. You can now set chart appearance in a variety of ways as shown in the following sample code.

// 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");

You may visit the following article for more details about setting chart appearance:
Setting chart appearance

For trials purpose, download the latest version here:
Aspose.Cells for .NET (Latest Version)

Here is a ready to run solution which can be used to test the product features with minimal effort.