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

mustang

New Member
Joined
Dec 27, 2005
Messages
35
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?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Have 2 series, one for Supplier, one for Customer, and plot date vs amount on an X-Y scatter as lines.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,911
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top