Combined chart type support?

Aspose.Cells Product Family
1

Hi,

is there any future support for a combined chart type - as in excel line with bar?

Thanks in advance

Michael Mann

2

Dear Michael,

Currently Aspose.Excel only supports a comined chart type of line,column and pie. If a chart of line with bar is critical to your application, we will add it in the future releases. It will take about 3-4 weeks.

3

so, i will figure it out if the available ones are adequate to our needs. which type is the combined line column type?

thanks

Michael Mann

4

Hi Michael,

Please check detailed document on creating a chart, follow the link below:
Creating and Customizing Charts for reference.

Now you can create a custom chart type with the first series type of line and the second series type of column.

5

@Mischi,
Aspose.Excel is no more available now and is discarded. It is replaced by another product Aspose.Cells which has all the features available in its predecessor as well as support for different advanced features in MS Excel. Combined chart types can be created using this new product as demonstrated 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["A4"].PutValue(110);
worksheet.Cells["B1"].PutValue(260);
worksheet.Cells["B2"].PutValue(12);
worksheet.Cells["B3"].PutValue(50);
worksheet.Cells["B4"].PutValue(100);

// 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 NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
chart.NSeries.Add("A1:B4", true);

// Setting the chart type of 2nd NSeries to display as line chart
chart.NSeries[1].Type = Aspose.Cells.Charts.ChartType.Line;

// Saving the Excel file
workbook.Save("output.xls");

Output

Combined Chart
Combined Chart898×864 108 KB

For detailed information on creating a chart, follow the link below:
Creating and Customizing Charts

The following link points to the free trial version of this product:
Aspose.Cells for .NET (Latest Version)

A detailed runnable solution is prepared which can be used to test the product features without writing any code. It can be downloaded here.