Chart point colours to show time trend

[Guest]

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]

Hi,

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

Cheers
Andy

 

[Guest]

Yes, but what I want is to show say change in price against change in volume
(for an example), over say 2 years, with the colour of the plot points
progressing from e.g. blue to red (via magenta on the way) over the two
years, so you can track the data over time. I've seen it done, but I think
elsewhere (different system, quite possibly).

It's a question of setting up a relatively slow progression in the colour
changes...

 

[Andy Pope]

The conditional approach will work but it would require quite a few
helper columns.

Another way would be via VBA.

do you have data about the age of each point in another column or are
the points within the column already in age order?

 

[Guest]

They're in date order, with the dates next to them (so both!).

 

[Andy Pope]

Here is a worked up example.
http://www.andypope.info/charts/spectrum.htm

Cheers
Andy

 

[Guest]

Great - that looks ideal (excel-lent?). Thanks for the help Andy!

 

[Andy Pope]

You're welcome.

Great - that looks ideal (excel-lent?). Thanks for the help Andy!

: