Hello, I'm trying to make a chart that will display how a price develops over time.

I have to calculate the price i want to display by multiplying two other prices that i have alot of pricedata on.

The problem is as follows, one of the subprices has a price for every day of the year, but lack data for weekends and some random days for the other price. Let me demonstrate:

date | price1 |

1.1.09 | 5 |
1.2.09 | 6 |
1.3.09 | 5 |
1.4.09 | 4 |

date | price2 |

1.1.09 | 5 |
1.3.09 | 6 |
1.4.09 | 5 |
1.5.09 | 4 |

The volumes of data makes it very time consuming for me to insert lines in the data for price2, and I dont know another way to do it.

Any help would be appreciated!

Thanks.