Since we know, MS Excel does not support dualaxisverticalbar chart type, even aspose is not supporting the same. Please provide a workaround for the same.
Currently we are using bar chart as the chart type for rendering dualaxisverticalbar chart.
The issue with this is that Legends are not rendered properly. Please see the attachment which is generated using Aspose.
Please help us with to identify a workaround for the same.
Attached is a sample chart data and the input xml used to form the chart data.
Hi Pratik,
Thanks for your posting and considering Aspose.
Are you using Aspose.Cells to generate your chart or some other component? If some chart is not creatable using Microsoft Excel then Aspose.Cells will also not able to create it.
Also, I checked your chart inside the SampleExcelData.xls and it looks fine. I did not notice any issue with it. The legend is also looking good.
Please also provide us your sample code that you used to generate your chart and provide us your expected chart which you can create manually using Microsoft Excel and post it here for our reference. We will look into it and help you asap.