How to create snail trail charts?

[boyc]

Does anybody know how to create snail trail charts in Excel?
I found zero information on the subject on the internet using variou
search engines

 

[boyc]

By the way, a snail trail chart is a scattered plot that shows th
position of the data points progressing with time.

For example, the average return and volatility of an investment fun
changes over time. By increasing the size of the data points on th
chart with respect to time gradually, we'll be able to see the trend o
the return/risk charateristics of the fund over time

 

[Jon Peltier]

http://www.thevirtualvine.com/libby.html
This snail trail is a spiral, used as a children's learning aid.

http://www.aviationtoday.com/cgi/rw/show_mag.cgi?pub=rw&mon=0603&file=0603eye_on_the_fleet.htm
This snail trail shows an aircraft's flight path over time. (Also used
with ships, etc.)

http://www.assetrisk.com/downloads/Sample ChartWise Report 2.pdf
This snail trail shows how a fund's position on the efficiency chart has
evolved over time.

http://www.mercermpa.com/unique/MPA_Australia_2003_A4.pdf
This snail trail shows the relative position of the manager on a
risk/return diagram over consecutive rolling periods.

The navigation-related snail trail chart is an XY scatter chart overlaid
on a map.

The finance-related snail trail charts are simply XY Scatter charts
(subtype Markers and Lines) plotted on appropriate axes of risk and reward.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______