how to change the chart axis of excel automation by MFC

Dear Gurus,

I use MFC to automate excel to plot charts. I want to change the axis range of the chart.
Do you know how I can do that?
Thank you in advance!

Jing

One again I take this from a very old program. It will be similar but the
exact method names have probably changed.

Code:

---

Axis axx, ayy;
axx = chart.Axes(COleVariant((short)1), 1);
axx.SetMaximumScaleIsAuto(FALSE)
axx.SetHasMajorGridlines(FALSE);
axx.SetMaximumScale(20.0);
axx.SetMinimumScale(0.0);
ayy = chart.Axes(COleVariant((short)2), 1);

...etc....

---

Dear Tom,

Thank you so much!
They change a little bit, but essentially it is the same thing. I browed the msdn library, unfortunately cannot figure out the parameter in the Axes method.
Thank you again! You are such a life saver!

Jing