Hi Team,
I wanted to plot Line chart, where the values/series I want should be in a worksheet assigned by me.
When I name this worksheet with hyphen in it ; chart is not getting plotted.
Could you please check and guide on same?
I’m attaching source code used and corresponding xls in zip file for ref.
Thanks!
Nachiket Aspose.zip (5.2 KB)
Please notice, I am able to reproduce the issue as you mentioned by using your sample code segment. I found chart is not being plotted if “-” (hyphen) is used in Worksheet name. I have logged a ticket with an id “CELLSJAVA-45045” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
@jnachi16
Please change codes as the following:
serieses.add("'Work-Sheet1'!$A$1:$B$3", true);
If the sheet’s name contains special characters , please add single quotation marks for worksheet in the formulas.