Auto adjust chart width

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Auto adjust chart width

Last post 12-08-2010, 8:44 AM by Amjad Sahi. 1 replies.


	Sort Posts: Previous Next

12-07-2010, 11:54 PM 272540

srinudhulipalla
Joined on 01-20-2009
Bangalore, India
Posts 141

Auto adjust chart width

Attachment: Present (inaccessible)

Hi there,

I am building a chart dynamically, if the X-axis data is less (ex: 10 rows in data table) the chart is showing fine with all labels.

But if the table has more no.of rows (ex: 35 as in attached screen shot), the chart is loosing the data to display in X-axis, but the data markers are showing fine for each axis.

If I increase the width of the chart, then I am able to see X-axis labels. So how could I increase the width of chart automatically depends on the data table of the chart?

PFA to check how the X-axis is missing the labels, but data marker in chart are showing properly.

Srinu Dhulipalla

Filed under: chart

12-08-2010, 8:44 AM 272658 in reply to 272540

Amjad Sahi
Joined on 08-30-2006
Posts 18,411

Re: Auto adjust chart width

Hi,

Well, Aspose.Cells will work similar to MS Excel. You may try to create your desired chart manually in MS Excel and check the issue.

If you have different opinion, kindly do create your desired chart in MS Excel with your desired length (also find out if some of the labels are lost or not), and post the file here. We will check it soon.

Also to increase the chart's width and height, you may try:
chart.ChartObject.HeightCM = intNumber;
chart.ChartObject.WidthCM = intNumber;

Thank you.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us