We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Chart data from different sheet?

Sorry if asked before, but I haven’t found the answer yet. Is there a way to create a chart and reference data that resides on a different sheet than the one you add the chart to?


Thanks.

Hi,


Yes, sure it is easy to do it with Aspose.Cells for Java. See the topic for your reference:
http://docs.aspose.com/display/cellsjava/Manipulating+Designer+Charts

Note: see the example: "Example 1: Creating a Chart" especially where the data resides in "Data" sheet and chart resides in "Chart" sheet.

Thank you.