Legends scroll bar

Aspose.Cells Product Family
1

Hello Team,

If we have 30 series data in line chart and if chart height is 350 and width is 750 then all legends are not shown. If we increase the height then all legends are shown. But there is limitation to increase height dynamically as well. Can we show scroll bar instead in such scenario.

Thanks
Aman

2

@amanguest353,

Aspose.Cells follows MS Excel standards and specifications. I have a doubt if we can add scrollbars with charts in MS Excel, so Aspose.Cells may not support it. If you still think it is possible in MS Excel, please share a sample Excel file (containing a chart with scrollbars). We will check on how to do it via Aspose.Cells APIs.

PS. please zip the Excel file prior attaching.

3

Thank for the information.
Is it possible to change height and width of the Legend Area ?

4

@amanguest353,

You may try to use setHeight and setWidth attributes to the height/width of legend frame:
e.g.
Sample code:

chart.getLegend().setHeight(int_Height);
chart.getLegend().setWidth(int_Width);