I am working on Scatter chart with data lines. Please find the sample attached.
/bin/debug file contains Test_template.xls, wherein two charts are displayed. I need to set data on the second chart programmatically so that it looks like Chart1.
But here whenever I try to add XValues and YValues, it creates one more additional series and setting the data incorrectly.
So I tried setting the series as "," separated data points. In that case it sets data but I am not able to set DataLabels on Chart2 exactly same a Chart1. For example:
If Y data values set like=> "=Graphs!$F$8:$G$8"
it doesn't work
but if set like "=Graphs!$F$8,Graphs!$G$8"
this works. I can use this way but in this case too I am not able to set DataLabels as desired.
Please look at the sample application I attached and let me know ASAP.
Thanks & Regards