Convert Chart to Localized Image with C++
Scenario
In what scenario would we need to set localized region for a chart?
When you open an xlsx file with a chart in Excel, in this case, suppose you open it with a Spanish Regional Setting in Excel, you can see the elements in the chart area, such as Chart Title and Legend, translated into Spanish. But when you save this chart as a picture with Aspose.Cells, you may encounter the following issue:
In this scenario, the Chart Legend in the output picture is not the same as in Excel; it remains displayed in English by default. Now you can solve this issue by setting localized region for the chart. With the correct settings, the following elements will be rendered according to your localization settings.
Supported elements
The following elements in the chart can be rendered according to your localization settings.
| Supported elements | default value in the English environment |
|---|---|
| Axis Title Name | Axis Title |
| Axis Unit Name | Hundreds, Thousands… |
| Chart Title Name | Chart Title |
| Legend Increase Name | Increase |
| Legend Decrease Name | Decrease |
| Legend Total Name | Total |
| Other Name | Other |
| Series Name | Series |
Operation Steps
The following example will show you in detail how to set localized region to achieve the effect you want.