Customizing Charts with C++

Creating Custom Charts

So far, when we’ve discussed charts, we’ve looked at standard charts that have their standard formatting settings. We only define the data source, set a few properties, and the chart is created with its default format settings. But Aspose.Cells APIs also support creating custom charts that allow developers to create charts with their own format settings.

Developers can create custom charts at run-time using Aspose.Cells.

A chart is composed of a data series. Each data series in Aspose.Cells is represented by a Series object whereas SeriesCollection object serves as a collection of Series objects. When creating a custom chart, developers have the freedom to use different types of charts for different data series (collected in the SeriesCollection object).

The example code below demonstrates how to create custom charts. In this example, we are going to use a column chart for the first data series and a line chart for the second series. The result is that we add a column chart, combined with a line chart, to the worksheet.

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
using namespace Aspose::Cells::Charts;
int main()
{
Aspose::Cells::Startup();
<span class="c1">// Source directory path

    U16String srcDir(u"..\Data\01_SourceDirectory\");

<span class="c1">// Output directory path

    U16String outDir(u"..\Data\02_OutputDirectory\");

<span class="c1">// Create a new workbook

    Workbook workbook;

<span class="c1">// Add a new worksheet to the workbook

    int sheetIndex = workbook.GetWorksheets().Add();

<span class="c1">// Obtain the reference of the newly added worksheet by passing its sheet index

    Worksheet worksheet = workbook.GetWorksheets().Get(sheetIndex);

<span class="c1">// Add sample values to cells

    worksheet.GetCells().Get(u"A1").PutValue(50);
worksheet.GetCells().Get(u"A2").PutValue(100);
worksheet.GetCells().Get(u"A3").PutValue(150);
worksheet.GetCells().Get(u"A4").PutValue(110);
worksheet.GetCells().Get(u"B1").PutValue(260);
worksheet.GetCells().Get(u"B2").PutValue(12);
worksheet.GetCells().Get(u"B3").PutValue(50);
worksheet.GetCells().Get(u"B4").PutValue(100);

<span class="c1">// Add a chart to the worksheet

    int chartIndex = worksheet.GetCharts().Add(ChartType::Column, 5, 0, 15, 5);

<span class="c1">// Access the instance of the newly added chart

    Chart chart = worksheet.GetCharts().Get(chartIndex);

<span class="c1">// Add NSeries (chart data source) to the chart ranging from &#34;A1&#34; cell to &#34;B4&#34;

    chart.GetNSeries().Add(u"A1:B4", true);

<span class="c1">// Set the chart type of 2nd NSeries to display as line chart

    chart.GetNSeries().Get(1).SetType(ChartType::Line);

<span class="c1">// Save the Excel file

    workbook.Save(outDir + u"output.xls");

<span class="n">std</span><span class="o">::</span><span class="n">cout</span> <span class="o">&lt;&lt;</span> <span class="s">&#34;Chart created successfully!&#34;</span> <span class="o">&lt;&lt;</span> <span class="n">std</span><span class="o">::</span><span class="n">endl</span><span class="p">;</span>

<span class="n">Aspose</span><span class="o">::</span><span class="n">Cells</span><span class="o">::</span><span class="n">Cleanup</span><span class="p">();</span>

}

Currently, Aspose.Cells only supports custom charts that combine pie, line, column, and column stack charts but more charts will be supported in future releases.