cheers richard. the formatting thing is what i needed to do.

Out of interest is there a way of keeping past data values on the chart? The x axis is time so say past data for the last 2 hours?

like I said, this is a web query so the data does not stay int he spreadsheet.

Thanks