Archive for December 11th, 2011

Excel poisoning #8: customizing chart programmatically (C#)

December 11, 2011

Want to change font size to axis’ labels?

Here is a brief sample, part II:

IOPXLS.Axis chartAxisY = myChart.Axes(XlAxisType.xlCategory) as IOPXLS.Axis;
chartAxisY.TickLabels.Font.Size = myChart.ChartTitle.Characters.Font.Size; 

This snippet sets axis label foint size, same as chart title.

Technorati tags: Excel, Csharp