Timeline/Line Chart

[Craig P]

Hi

I'm trying to create a chart that displays auction bidding information.  The chart would need to show a reserve price line with no markers, in other words if you hover over the reserve line, no tooltips would appear.

The other line would display the timestamp the bid price was received.  When you hover this line, the marker would display, the timestamp of the bid, the name of the bidder and the bid amount.

The x-axis would represent the price and the y-axis is the auction duration.

I've gone through several different chart but can't seem to find that matches the data set being supplied to the chart.  Any ideas what chart might suit the dataset.

Sample dataset

      dataTable.addColumn({type: 'string', id: 'Bidder'});

      dataTable.addColumn({type: 'date', id: 'Timestamp'});

      dataTable.addColumn({type: 'number', id: 'Bid'});

      dataTable.addColumn({type: 'number', id: 'Reserve'});

      dataTable.addRows([

        ['Fred Flintstone', new Date(0,0,0,12,1,30),  15000,  65000],

        ['Mary Poppins',    new Date(0,0,0,12,1,41),  16000,  65000],

        ['Adam Davies',     new Date(0,0,0,12,1,47),  18000,  65000],

        ['Fred Flintstone', new Date(0,0,0,12,2,02),  20000,  65000],

        ['Adam Davies',     new Date(0,0,0,12,2,10),  23000,  65000],

        ['Mary Poppins',    new Date(0,0,0,12,2,18),  26000,  65000],

        ['Adam Davies',     new Date(0,0,0,12,2,24),  30000,  65000],

        ['Fred Flintstone', new Date(0,0,0,12,2,27),  33000,  65000],

        ['Bill Bryson',     new Date(0,0,0,12,2,31),  35000,  65000],

        ['Adam Davies',     new Date(0,0,0,12,2,35),  40000,  65000],

        ['Fred Flintstone', new Date(0,0,0,12,2,41),  45000,  65000],

        ['Mary Poppins',    new Date(0,0,0,12,3,01),  50000,  65000]

      ]);

Something like this chart created in Excel

thanks