How to change Value Axis Display Unit Label Format

Aspose.Cells Product Family
1

I created a chart and be able to change the format of ValueAxis format under TickLabel, the chart have a display unit label, how can I change its format?

2

Please try:

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
Cells cells = sheet.Cells;

cells["A1"].PutValue(10000);
cells["A2"].PutValue(20000);
cells["A3"].PutValue(30000);

Chart chart = sheet.Charts[sheet.Charts.Add(ChartType.Column, 3, 3, 13, 8)];
chart.NSeries.Add("A1:A3", true);

chart.ValueAxis.DisplayUnit = DisplayUnitType.Thousands;

3

Thanks, what about font size and color, can it be changed?

4

No, this feature is not supported yet.

We are now working on enhancing chart APIs and will complete it in about 4-6 weeks. In that time this feature will be available.

5

Thanks. I am looking forward for those enhancement, especially on handling chart that already in the excel file.