Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
First step, you need to define a class “ChartChineseSetttings” that inherit from ChartGlobalizationSettings. Then, by rewriting the related functions, you can set the text of the chart elements in your own language. Code example:
In this step, you will use the class “ChartChineseSetttings” you defined in the previous step. Code example:
Workbook wb = new Workbook("Chinese.xls");
wb.Settings.GlobalizationSettings.ChartSettings = new ChartChineseSetttings();
Chart chart0 = wb.Worksheets[0].Charts[0];
chart0.ToImage("Output.png");
Then you can see the effect in the output image, the elements in the chart will be rendered according to your settings.
In this example, if you do not set Chinese Region for a chart, the following chart elements may be rendered in the default language, such as English. After the above operation, we can get an output chart picture with Chinese Region.
| Supported elements | Value in this example | 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 |
|
|
Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.