When calling Chart.RefreshPivotData() on a chart - even without making any changes to data in the underlying PivotTable - causes the output chart labeling to be incorrect.
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v126.96.36.199 and see if it makes any difference and fixes this issue.
your issue still occurs, then please provide us your sample code and
source excel file that we could use to replicate this issue at our end.
We will look into it and help you asap.
Unfortunately, the issue persists.
Thanks for your files, code and using Aspose.Cells.
We were able to observe this issue after executing your sample code with your source excel file using the latest version: Aspose.Cells
for .NET v188.8.131.52. The chart created by Aspose.Cells is not like the expected chart which you have provided.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-43632 - Pivot Chart is not showing correct data
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)
Your issue should be fixed in it.
Let us know your feedback.