Charts/graphs in php

Generate charts on the fly, taking information from mysql database. Site is price comparison site. Idea is to situate where the seller of a product is situated compared to the other sellers of the same product. Each row in database looks like this: seller, product, start date, end date, price You need to write php code that generates a chart on the fly that shows - X: date from now till 1 year back, Y1: highest price Y2: price of 10th best vendor Y3: average price of 10 best vendors Y4: price of vendor under consideration Y1 and Y2 form together a semi transparent zone in the graph. On request an example can be sent of how the chart should look Use JPGRAPH ([login to view URL]) or other chart component. After the coding works in standalone php, it must be integrated in joomla (using "include" command)