Need line chart, with two Y axes, and unified X axis by date...

[mustang]

I have a list of offers for a particular proposal, which looks something like this:
Offer name.....Date........Amount
Supplier.............12/4/06....$20
Supplier.............5/19/07....$21
Customer...........5/24/07....$15
Supplier.............6/15/07....$18
Customer...........7/2/07......$16
Handshake.........10/5/07.....$17.50

I want to plot the Supplier offers and Customer offers on separate lines, on the same chart. The X and Y axes scales should be the same for both lines.

However, I've only been able to figure out a way to chart the lines that doesn't incorporate the dates. Effectively, this makes it look like the next sequential Supplier and Customer offer occur at identical times.

Alternatively, I've figured out a way to incorporate only one set of dates (either Supplier or Customer) by charting off the table below instead. This causes the other dataset to be skewed, though.

Offer name.....Date........Amount
Supplier.............12/4/06....$20
Supplier.............5/19/07....$21
Supplier.............6/15/07....$18
Handshake.........10/5/07.....$17.50

Customer...........5/24/07....$15
Customer...........7/2/07......$16
Handshake.........10/5/07.....$17.50

Any suggestions on how to have two datasets graphed on the same line chart, with differing X coordinates on the same X scale?

 

[GlennUK]

Have 2 series, one for Supplier, one for Customer, and plot date vs amount on an X-Y scatter as lines.

 

[mustang]

Glenn, you're my new best friend...thank you!!!

 

[GlennUK]

Glenn, you're my new best friend...thank you!!!

My pleasure!