I have created a Chart control programatically. I set the minimum value of
the horizontal axis by using the following code

Axis ax = chart.Axes(XlAxisType.xlValue, XlAxisGroup.xlPrimary) as Axis;
ax.MinimumScale = 10000.0;

I need to change the format of the values displayed in the axis from number
to currency instead of number. How do I do this programatically? How can I
programatically give format code for the axis.

Thanks in advance.