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

[DaxiaCRES]

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!

[Tom Frohman]

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.

[DaxiaCRES]

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!

[Tom Frohman]

I answered this in your other post.

Tom