Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
How to set Series invisible
Contents
[
Hide
]
How to set series invisible in Excel Chart
In an 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 a series invisible using Aspose.Cells:
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.
