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
Bookmarks