Does anyone have a template for creating a slip chart in Excel

[Slip charts in Excel]

 

[Andy Pope]

Hi,

Can you provide a link to an example of what you mean by 'Slip Chart'?

Cheers
Andy

Slip charts in Excel wrote:

 

[Jon Peltier]

I assume he means this:
http://www.noweco.com/qei/qeie10.htm

not these:
http://www.smycmarina.com/slipchart.html
http://personalinjury.cprlaw.com/Causes-of-Slip-and-Fall-Accidents-Chart--3-602-206.html

If I interpret the first link properly, X is the predicted finish date and Y
is the date at which the prediction was made. For each line on the chart,
you need a column of predicted dates and prediction dates. Make an XY chart
from the first pair of date columns, Double click the vertical axis, and
change the scale so it plots in reverse order and the axis crosses at the
maximum. Copy each successive pair of data columns, select the chart, and
paste special as a new series with the X (category) data in the first
column.

If you're feeling advanced, you could check out the "Series with Distinct X
Values and Shared Y Values" option on this page, since all the Y values are
the same:
http://peltiertech.com/Excel/ChartsHowTo/VBAExcelXYCharts.html

Or you could try the Quick XY Chart utility:
http://peltiertech.com/Excel/ChartsHowTo/VBAExcelXYCharts.html#utility

- Jon