Hi,
The Charts Class in Java has the below 2 overloaded methods:
addChart(int chartType, int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn)
addChart(int chartType, int row, int column, int left, int top, int width, int height)
In .net we have only one.
Chart.Add(ChartType type, int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn);
My questions is:
In .net, is it possible to plot a chart in a worksheet, such that the chart is not bound to the cells.
I mean it should be placed anywhere in the worksheet. It can start from middle of a cell or end in the middle of the cell.
Please see the attached image. I am expecting to do something that this.
thanks and regards,
Vinay A
Hi Vinay,
I think you may use Chart.ChartObject.UpperDeltaX/Y attributes for your need. See the sample code below:
chart.ChartObject.UpperDeltaX = 250;
chart.ChartObject.UpperDeltaY = 150;
Thank you.