Add hyperlink to chart

Aspose.Cells Product Family
1

Hello,

is there a way to add hyperlink to chart through aspose.cells for java? There is a way to add hyperlink to shape using shape.addHyperlink, or to cell using worksheet.getHyperlinks.add(), so I wonder if there is some similar option for Chart?

Regards,
Milorad

2

@Milorad,

Thanks for your query.

I could not find such a feature in MS Excel when manually trying to add hyperlink to a chart in Excel worksheet. Aspose.Cells follows MS Excel standards and specifications for chart and shapes. If you still think this is possible in MS Excel, kindly do provide details and sample file (containing a hyperlinked chart), we will check how to do it via Aspose.Cells APIs.

3

Hi, the example is attached, there is a hyperlink (www.google.com) on chart, you can check it out.

chart-with-hyperlink.zip (9.5 KB)

4

@Milorad,

Thanks for the file.

I lately found the feature is supported in MS Excel so Aspose.Cells also supports this already. Please see the sample code for your reference:
e.g
Sample code:

Workbook workbook = new Workbook("f:\\files\\chart-with-hyperlink.xlsx");
         //Get the Chart from the first worksheet.
         Chart source = workbook.getWorksheets().get(0).getCharts().get(0);
         ChartShape cshape = source.getChartObject();
         //Add/update hyperlink for the chart shape.
         cshape.addHyperlink("https://www.yahoo.com");
         //Save the Worksheet
         workbook.save("f:\\files\\out1.xlsx");

Hope, this helps a bit.