Hi,

See Jon Peltier's example of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

AndyE wrote:
Is there any way that I can plot two sets of data against each other, while
getting the colour to vary depending on how recent the data points are?

I'm using a scatter graph to build up a pattern of the interaction between
two variables, but it would be great to know where in the (now 900) data I
currently am, and what the short-term trends are...

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info