How to set Series invisible with Node.js via C++

How to set series invisible in Excel Chart

In Excel chart, you can right-click a chart, click “Select Data”, and in the pop-up window, you can set whether a series is visible by checking or unchecking it. You can download the following sample file and operate it in Excel as shown in the figure to achieve this function. Next, we will tell you how to achieve this using the Aspose.Cells library.

How to set series invisible using Aspose.Cells

We use the following code to set series invisible using Aspose.Cells:

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "SeriesFiltered.xlsx");
// Loads the workbook which contains hidden external links
const workbook = new AsposeCells.Workbook(filePath);

const charts = workbook.getWorksheets().get(0).getCharts();
const chart = charts.get("Chart 1");
const nSeriesFiltered = chart.getFilteredNSeries();
const nSeries = chart.getNSeries();
nSeries.get(1).setIsColorVaried(true);
nSeries.get(0).setIsColorVaried(true);
workbook.save(path.join(dataDir, "output.xlsx"));

You can get the following Input file and output file.

As shown in the figure below, the first two series which were originally visible, have become invisible in the output file.