Size and positioning of chart

Aspose.Cells Product Family
1

How can I position the chart and control its height and width? e.g. if the data and the chart is on the same sheet, how can I place the chart after the data? Or, if they are on different sheets, how can I position the chart at a particular location within the chart sheet and control its height and width?

2

When you use the Charts.Add method, you can specify the chart size and position.

3

I already tried that. It does not seem to make any visible difference. I used the C# sample project from your Aspose.Cells download. It plots the chart on the second sheet with coordinates 0,0,0,0. I tried changing it to different values but it still looks the same.

4

The cost pareto demo create a new chart worksheet. In a chart worksheet, chart size and position cannot be adjust. To plot chart in a normal worksheet, please check sales by category demo. Or you can check Creating a Simple Chart.

To reference data in another worksheet, please try:

int chartIndex = excel.Worksheets[0].Charts.Add(ChartType.Column, 3, 3, 17, 10);
Chart chart = excel.Worksheets[0].Charts[chartIndex];
//Add chart data source
chart.NSeries.Add("Sheet2!A1:C3", true);

5

Thanks, Laurence. That worked.

6

Besides specifying the top-left and bottom-right coordinates in .Add method, is there any other way to control the “Height” and “Width” of the chart or the plot area?

7

You can try to use Chart.ChartArea and Chart.PlotArea to set them.

8

Thanks, Laurence.