Chart data from different sheet?

Aspose.Cells Product Family
1

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.
2

Hi,


Yes, sure it is easy to do it with Aspose.Cells for Java. See the topic for your reference:


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.