View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Does anyone have a template for creating a slip chart in Excel

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

not these:
http://www.smycmarina.com/slipchart.html
http://personalinjury.cprlaw.com/Cau...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/ChartsH...lXYCharts.html

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

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


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

Slip charts in Excel wrote:

--

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