Free Support Forum -

How to change Value Axis Display Unit Label Format

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?

Please try:

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


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

chart.ValueAxis.DisplayUnit = DisplayUnitType.Thousands;

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

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.

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