Does anyone have a template for creating a slip chart in Excel
|
Does anyone have a template for creating a slip chart in Excel
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 |
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 |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com