Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Jan 13, 2011 2:24 am

Can I increase the PlotArea to use the wasted spaces as much as possible?

smilesunshine99
 
Posts: 8
Joined: Tue Dec 21, 2010 7:09 am

Mon Jan 17, 2011 11:13 am

If you find that your document waste so much space, you can increase the PlotArea by setting the leftColumn, topRow, rightColumn and bottomRow of the chart. You can use the following code:
chart.LeftColumn = 1;
chart.TopRow = 6;
chart.RightColumn = 11;
chart.BottomRow = 29;
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS