Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
How to set point as total
Contents
[
Hide
]
What is “Set point as total” in an Excel chart
In some Excel charts, for example, a Waterfall chart, some point data are the sum of the previous points, so you may need to “set point as total”. We will show the sample code and an illustration below.
A Waterfall chart that needs to “Set point as total”
This picture shows a Waterfall chart in Excel. We can see that there are four data points starting with “Total”, and they are used to sum all the previous data points.
In this picture, the settings are not exactly right; when we select the point “Total 2024”, we can see that the “Set as total” option is not checked in Excel.
Attached below is the sample Excel file that needs to be modified, and we will use Aspose.Cells to set it up correctly.
Use Aspose.Cells to “Set point as total”
We use the following code to get the file set up correctly:
You can download the corrected output file.
As shown in the figure below, the four “Total” data points are set correctly, and you can see the difference from the previous chart.
