Show total values of stacked column chart on top

Aspose.Cells Product Family
1

Hi,

I’m working on a stacked column chart using Aspose Cells Java API.
Need assistance in displaying total values of series on top.

Attaching sample excel with chart for your reference.
Stackedbar.zip (11.4 KB)

Thanks in Advance

2

@SriG,

Could you share your expected chart (total values displayed at the top) here, you may create your desired chart in MS Excel manually. We will check and help you on how to do it with Aspose.Cells API.

3

To generate it manually, I’ve added Totals column in table and able to display at sum of values at top of the stack.
But in the table, we may or may not have the Totals column available.

Sample excel with expected chart: Stackedbar-datalabels.zip (11.9 KB)

4

@SriG,

You have to do the same way if you want to accomplish the task via Aspose.Cells APIs. For example, Add Total column with relevant data/values into respect cells in the source. Add new data series (in your case it is line chart type) to the chart with no line and border color. Then show data labels values as Above position.