Convert Chart to Localized Image with JavaScript via C++
Scenario
In what scenario would we need to set a localized region for a chart?
When you open an .xlsx file containing a chart in Excel, and suppose you have a Spanish regional setting, you can see that elements in the chart area, such as the chart title and legend, are 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. You can solve this issue by setting a 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 an 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 examples show in detail how to set a localized region to achieve the desired effect.