how to plot different x axis values in the same graph of excel automation by MFC?

Dear Gurus,

I have some difficulty in automatically plotting several curves in the same graph in excel by MFC.
In MFC, I automate the chart plot by calling ChartWizard. If the data used to plot sharing the same
x value, for example, they are listed as x, y1, y2..., it is easy to plot out these curves on the same graph. Then I don't know how to plot these when data are not having the same x value. For instance, x1, y1, x2, y2, ....ChartWizard seems cannot do that automatically. Is there any method I can use to plot y1(x1), y2(x2) on the same graph?

Thank you!

http://www.codeguru.com/forum/showth...riesCollection

I created the post above seven years ago with Visual Studio 6 on excel 2000.
The commands might have changed but you will do the same thing in the current version.

Thanks, Tom!
It really works in your way. The class names may be different, but the basic idea is the same.
BTW, do you know is there anyway I can define the axis range in the excel chart in MFC?
Appreciate your help a lot!

I answered this in your other post.

Tom