How to Get Object Position in Chart

Possible Usage Scenarios

In some scenarios, when you are using an Excel chart, you may need to get the position of the objects in the chart. You can easily achieve this requirement with Aspose.Cells.

Example: Get object position in chart

The following sample code loads the sample Excel file and generates the output Excel file.

With the above code, you can get the position of the chart title and the chart’s PlotArea.
With the positional information, the shapes can be placed in the corresponding position in the chart.
The output is shown in the following picture, where one shape is placed in the top‑left corner of the PlotArea and the other shape is placed below the chart title.
todo:image_alt_text

Unit explanation and conversion

There are three units for the position of objects in a chart:

  1. Units expressed as a ratio of the chart area.

  2. Units of 1/4000 of the chart area. This is a unit used in older versions of Excel files, and it is not recommended.

  3. Units of pixels.

The conversion code for them is shown in the following code:

How to create a tornado chart How to change theme colors for chart series