Plotarea.Heigth

Aspose.Cells Product Family
1

Hello,

i need to set the height from the plotarea.

The height should be the height from the chartelement.

How do I get the height from the chart container?

regards martin

Chart chart = ws[1].Charts["Chart 1"];

chart.Move(5, 8, 44 , 15);

chart.NSeries.Clear();

chart.NSeries.Add(String.Format("=D{0}:D{1}", 7, zeileObereTabelleBlatt2), true);

chart.NSeries.CategoryData = string.Format("=C{0}:C{1}", 7, zeileObereTabelleBlatt2);

chart.PlotArea.Height =???

2

Hi,

Thanks for considering Aspose.

If you want to change the height of the plot area, you may use PlotArea.Height property. If you want to set chart's height you may utilize:

chart.ChartObject.Height=....;

Thank you.

3

Hi,

i tried your tip, but it still doesnt work:

This are the paramters of my Chartobject:

upperleftrow=5; lowerrightrow=25; height=420

so i set the chart.PlotArea.Height = 420,

but it is too small, then it has not the same height than the chartarea.

regards

martin

4

Hi,

The position of PlotArea is in unit of in units of 1/4000 of the chart area.

So please use chart.PlotArea.Y = 0,chart.PlotArea.Height = 4000,